PDA

View Full Version : Adding Percentages to a Pivot Table with Calculated Item



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.