Explain 2 advanced Pivot Table techniques on Excel?

Data Science, AI and ML
#1

Slicer is a helpful tool in linking multiple pivot tables. You can even mention that it will help in filtering data for all the pivot tables. It saves plenty of time.

Another good time-saving technique is to create a calculated field. This is how it can be set up:

  • Visit ‘Pivot Table Analyse’
  • Select ‘Fields, Items and Sets
  • Click on the ‘Calculated Field’ option
  • Enter the name of the new calculated field