Advanced Pivot Table Tricks #9.1 - Grouping Data without Data Model

#groupingDataInPivots #GroupDatesExcelPivot #GroupWithoutDataModel

If your pivot tables are *NOT* from data model, you can group any fields.

Dates can be grouped in to days / months / quarters / years
Numbers can be grouped by chunks
Text can be grouped by selecting items on the report

Here is a video detailing grouping options for non-data-model pivots.

For example workbook and resources visit:

[sagarkansal]

Awesome idea for grouping of text Chandoo. I was eagerly searching for this. You never disappoint us. Kudos.