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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Tables Rows 2
Help with pivot table 2
How do I create unique pivot tables from the same data 1
Can we connect Pivot to multiple source data (MS Access) 6
Is there a way to turn off Sum on Pivot Tables by default? 2
Pivot Table Query 3
is there a way to control the sheet name you add 3
Multiple pivot tables on same sheet with common report filter 1

Top