Pivot Filter Explode Macro

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.

image

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

Continue reading

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

image 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.

Estimated reading time 10 min

Continue reading