#Excel60Sec - How to create multiple Pivot Reports in one click?

preview_player
Показать описание
#Shorts

Instead of using Filter View of PivotTable, one can use this technique.

In case of filter view, you need to manually select a specific element to see the corresponding pivot report. But in this process, you get all the reports made instantly at a single click only.

Go to Pivot Table Options -- Show Report Filter Pages to have this enabled.
Рекомендации по теме
Комментарии
Автор

Nice pivot table trick..please upload kore

piyushBOMBAY