Forum Discussion
Percent change pivot table summary
Hi all, I am trying to get these % change fields to work properly. I know this has to be something simple, but can't seem to find an answer anywhere. The summary line in the pivot is taking a t...
- Hi Stephen,
Where is that formula in your screenshot coming from, is typed in those cells or is it a calculated field?
Also, have you used Power Pivot at all in the past? That's the new way to write formula in Pivot Tables (Excel 2013 onwards)
It looks like "% Change" is the field in the source table. With adding to Pivot Table it calculates for the group sum of percentage for the products, not per cent for entire group.
To calculate correctly better to add calculated field like =([2018]-[2017])/[2017] to the Pivot Table (if it's not added to data model; if added when the column in Power Pivot). When percentage will be in context and shall show correct result for the group.