In Excel, a pivot of average amount by province has its top-left cell at A3. Type the KPI-cell formula that reads Ontario's value from it.
In Excel, a pivot of average amount by province has its top-left cell at A3. Type the KPI-cell formula that reads Ontario's value from it.
Answer
=GETPIVOTDATA("amount", A3, "prov", "ON")
Field name, a cell anywhere in the pivot, then field–item pairs. Keeps reading ON after a re-sort; a plain =Pivot1!B4 link reads whatever row 4 becomes.