CODEWITHSUNDEEP
excelpivotpivot-tableexcel-2013powerpivot
JaperTIA
JaperTIA

Reputation: 129

Excel PivotTable "Show Values As % of item" not correctly calculated

I am having trouble using the "Show value as"-functionality in my pivottable in Excel 2013. My pivot should look like the table below:

However, when I calculate "Show value as % of "1. Turnover", only the row headers (being Turnover, General costs and variable costs) are correctly calculated. The % of turnover for the items 70XXX, 61XXX, 60XXX) display "NA". Can anyone help me to explain how I should apply this functionality?

Thanks!

Jasper

enter image description here

Upvotes: 0

Views: 299

Answers (1)

JaperTIA
JaperTIA

Reputation: 129

I solved this issue by creating a calculated field.

DIVIDE(SUM('Table'[value]);CALCULATE(SUM('Table'[value]);'Table'[header]="1. Turnover";ALL('Table'[header];'Table'[subheader])))

Upvotes: 1

Related Questions