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. ...
Hello Lawrence_Lam_320,
The issue is happening because =B2 is a fixed cell reference, while the PivotTable layout changes depending on the slicer selection.
Instead, use GETPIVOTDATA.
Example:
=GETPIVOTDATA("Product A Sales",$A$1)
Where $A$1 is any cell inside the PivotTable.
This will return the Product A Sales value for the selected Country when a slicer filter is applied, and the Total Product A Sales when all Countries are selected.
You can also type = and click the PivotTable value cell directly. Excel will automatically generate the GETPIVOTDATA formula for you.