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)
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)
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)
- Wyn / Sergei, thanks for your responses and time. I was able to identify the issue and update the pivot table to where the subtotal fields reflected the correct %. I had to adjust some of the way the data was being passed from an Access data connect to do it, but it worked. To your point it would have been much easier to do in 2013+ but we are still stuck using 2010 here at work. Have a good rest of the week!