I have a Pivot Table which is filtered, so the number of rows in the table varies as the filter conditions change. I now want to be able to take data from the filtered pivot table and do some further calculations, such as calculate the Maximum value in a column. (I want to be able to do a variety of calculations, so I really need to be able to get the range/whole column).
GETPIVOTDATA() sounds like the right sort of thing to use, but I don't really understand the descriptions that I have read in the context of getting a range of cells.
Can someone please suggest something I could try or look at.
Many thanks
GETPIVOTDATA() sounds like the right sort of thing to use, but I don't really understand the descriptions that I have read in the context of getting a range of cells.
Can someone please suggest something I could try or look at.
Many thanks
