Tag Archives: Pivot Tables

Macro to Explode Pivot table by Filter Field Items

Refer to the previous post. We saw how Filter fields can be exploded into individual sheets and files. In this article, I am releasing a macro – which does all the hard work for you. Of course, you must use it at your own risk. The source code is also included for you to view, learn from and modify. Created by Raj Chaudhuri and myself.

PivotFilterExplode macro

Photo credit: Johnson Cameraface / Foter / CC BY-NC-SA

Continue reading Macro to Explode Pivot table by Filter Field Items

Unknown Gems: Explode Pivot Table by each filter item

Suppose you have Products in Filter area and Pivot Table shows Regional Sales by Month. There are 5 products. You want five sheets for each product separately- this is called Explode Pivot Table. But not by doing this manually. Here is how you do it (Reading time 7 min)

image

Continue reading Unknown Gems: Explode Pivot Table by each filter item

Knowledge Pack – Data Grouping (Text, Numbers and Dates)

Analytics is all about summarizing and grouping. Numbers are grouped into bins, text is categorized and dates are compressed into months, quarters and years. This series covers various quick and powerful methods to perform sophisticated grouping in seconds.

 data Grouping in Excel Knowledge Pack

Estimated reading time 10 min

Continue reading Knowledge Pack – Data Grouping (Text, Numbers and Dates)