• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help with Getpivotdata function?

vannguyen

New Member
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?

66008

66006
 

Attachments

  • Req 2020.xlsx
    93.5 KB · Views: 3
Last edited:
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).
 

Attachments

  • Copy of Req 2020.xlsx
    100.4 KB · Views: 3
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??
 
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)
Ok, I got it
Thanks for reply.
 
Back
Top