Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grouping in pivot table | Excel Worksheet Functions | |||
Pivot Table - Grouping | Excel Worksheet Functions | |||
Pivot table grouping | Excel Discussion (Misc queries) | |||
Pivot Table Grouping | Excel Discussion (Misc queries) | |||
Pivot Table Grouping | Excel Discussion (Misc queries) |