Is there a way to keep pivot tables from grouping rows with same n

A

AndrewEdmunds

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,
 
J

Jim Thomlinson

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