ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Grouping in a Pivot Table (https://www.excelbanter.com/excel-programming/272927-re-grouping-pivot-table.html)

Bernie Deitrick[_2_]

Grouping in a Pivot Table
 
Shinichi,

No sites that I am aware of, but to change how your data is grouped, simply drag / drop the row field button right or left to
increase or decrease its sort order: more important fields to the left. However, if you want unrelated fields to stay together, you
may need to create a 'helper' column in your data set (using a formula to concatenate field data), and sort based on that field.

HTH,
Bernie
Excel MVP


"Shinichi" wrote in message ...
Is there any site that shows "grouping" of a Pivot Table?

I have to group rows based on multiple conditions but I am
clueless where to start.

Any help is appriciated.

Shinichi






All times are GMT +1. The time now is 10:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com