Master GETPIVOTDATA to make better reports: Pivots are very powerful, but they carry a lot of baggage. If you want to harness the calculation might of pivots, but still use a friendly format in the output sheets, use GETPIVOTDATA.
This can lookup in to pivot tables and give values you want. See below demo:
Do you enjoy this Microsoft Excel tip ?
You can take the Complete Step-by-Step Microsoft Excel Training Course Here