Forum Discussion
Slicer
Hi Expertises, Need your help again. I have pivot table as below. I need to capture the Product A sales amount under the following scenarios. Filter. Select any one country in slicer NO Filter. ...
Use GETPIVOTDATA...
This function references PivotTable values by their labels, not by cell coordinates — so it works regardless of filter state.
=GETPIVOTDATA("Product A Sales", $A$1)
- "Product A Sales" – the value field name
- $A$1 – any cell inside your PivotTable (e.g., top-left corner)
Important: This returns the filtered total automatically.
- If one country is selected → shows that country’s Product A Sales
- If all countries are selected → shows Grand Total for Product A Sales
My answers are voluntary and without guarantee!
Hope this will help you.