Jun 26 2018 01:52 PM
Jun 26 2018 01:52 PM
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 total of the % changes. Screen shot attached. Thanks in advance.
Jun 28 2018 05:13 AM
SolutionJun 28 2018 06:40 AM
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.
Jun 28 2018 11:51 AM
Jun 28 2018 05:13 AM
Solution