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

Dealing with a Pivot Table (when I don't want to) 0
Keep a column of comments "with" pivot table as pivot tables datachanges, causing rows to be added a 0
Getting Two Rows in A Pivot with Identical Data 0
Help with pivot table 1
Creating Pivot Table with Macro using Multiple Sheets 0
Pivot table grouping issues 0
How do I create unique pivot tables from the same data 1
is there a way to control the sheet name you add 3

Top