Forum Discussion
Solved
How I calculate two average fields in pivot table
I'm trying to subtract two averages in pivot table using calculation filed option "average 2 - average 1" but the result comes out incorrect it's not the subtraction of both averages I change...
This doesn't work the way you think it does :)) What happens is illustrated in K2:N4 below:
If, with the above Table1, you expect the diff. shown in I8:I9 AFAIK this isn't doable with a classic PivotTable but with Power Pivot assuming you run Excel >/=2013 on Windows
This doesn't work the way you think it does :)) What happens is illustrated in K2:N4 below:
If, with the above Table1, you expect the diff. shown in I8:I9 AFAIK this isn't doable with a classic PivotTable but with Power Pivot assuming you run Excel >/=2013 on Windows
I didn't know about power pivot tools I thought it's just a subtraction between two values and it's done lol I appreciate your time in explaining the solution it's more clear now
- Glad we could help. To help others, please mark as solution (link at the bottom of each reply you get) either Riny_van_Eekelen or my reply - Thanks & Nice EOD