Help with Getpivotdata function?

[vannguyen]

Hi all
I have a pivot table like this?
Now I want to use getpivotdata to sum Type Service & Month but it appear #ref!
Can to fix it?

 

[GraH - Guido]

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).

 

[vannguyen]

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).

Thanks for sharing, but we must make 3 pivot table ??
Do we have another way to do it with only 1 pivot??

 

[GraH - Guido]

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)

 

[vannguyen]

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)

Ok, I got it
Thanks for reply.