Adding Percentages to a Pivot Table with Calculated Item
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.