Dear All,
Please help me to take the sale profit/loss report in percentage in pivot table now iam using manually,
Please find the attached file.
Thanking you in advance
Mubeen
Dear All,
Please help me to take the sale profit/loss report in percentage in pivot table now iam using manually,
Please find the attached file.
Thanking you in advance
Mubeen
Use calculated field feature of pivot table.
1) Keep your cursor on C1
2) Under option menu select click on formula function then select Calculated field
3)Now in click in formula area. Open the bracket, click on sales amount, press minus sign now click on COST OF GOODS SOLD close the bracket, now use / sign and click on COST OF GOODS SOLD.
4) Format the column with % sign.
hope this will help you.
thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks