| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to keep pivot tables from grouping rows with same n
Hello,
I am creating pivot tables based off of our balance sheet. There are 3 rows in my balance sheet called other. When I create the pivot table, it combines all of the others together into one row. Is there any way to stop this aside form renaming the row? Thanks, -- Thank You Andrew Edmunds |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a way to keep pivot tables from grouping rows with same n
Nope... Pivot tables aggregate based on groupings. That is the whole point to
pivot tables. You could change the names by appending blank characters to the end of the word... "Other" "Other " "Other " will for 3 different groupings. -- HTH... Jim Thomlinson "AndrewEdmunds" wrote: Hello, I am creating pivot tables based off of our balance sheet. There are 3 rows in my balance sheet called other. When I create the pivot table, it combines all of the others together into one row. Is there any way to stop this aside form renaming the row? Thanks, -- Thank You Andrew Edmunds |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Grouping in Pivot Tables | Excel Worksheet Functions | |||
| Grouping DATES in a pivot tables | Excel Discussion (Misc queries) | |||
| How do I get the grouping dialogue box to appear in Pivot Tables? | Excel Worksheet Functions | |||
| grouping in pivot tables | Excel Discussion (Misc queries) | |||
| Using Date Grouping in Pivot Tables | Excel Discussion (Misc queries) | |||
Linear Mode
