It is logic it returns errors as there is no "Service" total in your pivot.
I tend to use very little dimensions in my pivots, but make more pivots (sharing the same cache).
It is logic it returns errors as there is no "Service" total in your pivot.
I tend to use very little dimensions in my pivots, but make more pivots (sharing the same cache).
What is the reason not to duplicate the pivot? "Refresh All" will do.
If you want to use getpivotdata then I do not know about another way. You can revert to excels' standard functions like SUMIF/S.
Example [O14]=SUMIF(List!$E:$E,$L14,List!F:F)
What is the reason not to duplicate the pivot? "Refresh All" will do.
If you want to use getpivotdata then I do not know about another way. You can revert to excels' standard functions like SUMIF/S.
Example [O14]=SUMIF(List!$E:$E,$L14,List!F:F)