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

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