Error getpivotdata
in
The Complete Data Visualization Course with Python, R, Tableau, and Excel
/
Dashboard in Excel - Tables – Volume by Size
Hi there,
I have been following the instructions step by step and I am having trouble figuring out what am I doing wrong. Can someone help me? Please
2 answers ( 0 marked as helpful)
Hello,
Thank you for reaching out. The function looks good. Are these items contained in the pivot table, please? All items that are in your function need to be included in the pivot table for the slicers to work.
Best,
Ned
Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
If there are any spaces after the word "Volume" in the cell you are using as a reference ($B$29 in your example), then the formula will return an error.
Unsure if this is it, but I had the same issue and figured out that's what was going on.