jaydee
01-09-2019, 02:42 PM
Hi All,
Is it possible to add a percentage as a calculated item in a pivot table using row labels?
On the file attached, I have an income statement in a pivot table format, with sales and cost, but I want to show gross profit %, which would be (sales - cost of sales) / sales.
However, when I added calculated item formula, it returns #DIV/0!
Any ideas? Am I doing it wrong, or is it not possible? I highlighted the formula I created, and in cells E9 & F9 what the values should be.
Appreciate any feedback. Thank you.
Is it possible to add a percentage as a calculated item in a pivot table using row labels?
On the file attached, I have an income statement in a pivot table format, with sales and cost, but I want to show gross profit %, which would be (sales - cost of sales) / sales.
However, when I added calculated item formula, it returns #DIV/0!
Any ideas? Am I doing it wrong, or is it not possible? I highlighted the formula I created, and in cells E9 & F9 what the values should be.
Appreciate any feedback. Thank you.