Lesson#139: How to get rid of GETPIVOTDATA in PivotTable

Lesson#139: How to get rid of GETPIVOTDATA in PivotTable

We have discussed working with PivotTable in previous lessons. Here I am going to share a small tip about GETPIVOTDATA in PivotTable. How to get rid of GETPIVOTDATA in PivotTable.

get rid of GETPIVOTDATA

When we are making some calculations on the Pivot data field that complex GETPIVOTDATA confuses us a lot. I will show the easiest way to get rid of GETPIVOTDATA in PivotTable.

You need to follow these simple steps.

get rid of GETPIVOTDATA
  1. Click on the PivotTable 2. Click on the ANALYZE tab of PivotTable TOOLS 3. Click on the Options 4. Click on Generate GetPivotData
get rid of GETPIVOTDATA

Make your PivotTable so simple and presentable by using this small solution.

See also  Lesson#140: Color cells if cell value found in another column - Conditional formatting

Hi! I am Puspendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.

Leave a Reply

Your email address will not be published. Required fields are marked *

*