Last answered:

19 Dec 2023

Posted on:

21 Mar 2023

0

Error getpivotdata

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)
Instructor
Posted on:

22 Mar 2023

0

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

Posted on:

19 Dec 2023

0

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.


Submit an answer