Numbers pivot table hide certain columns

Question

Level 1

13 points

Numbers pivot table hide certain columns

I have a Numbers Pivot Table that has columns for each month by Category Sum Base Value and Category Sum % of Column Total.

I then have a Grand Total Sum Base Value and Grand Total %.

I don't need to see the monthly %...I only want to see the grand total % for each category...but preserve the monthly dollar amount by category.

In the pic I've attached, I want to eliminate the columns with the red arrows. I've also attached the Pivot Options screen.

Any way to do this in Numbers? I can eliminate the Grand Total column, but that's the opposite of what I need. I need to keep that and eliminate the "second" Amount (Sum) for each individual month.

I need simple explicit instructions, as I'm a Numbers newbie and not all that smart! LOL!

Posted on Apr 8, 2023 10:08 AM

Reply

Answer 1

SGIII

Level 8

37,550 points

Apr 9, 2023 12:19 AM in response to Gerald Malis

Gerald Malis wrote:

I don't need to see the monthly %...I only want to see the grand total % for each category...but preserve the monthly dollar amount by category.

All you need to do is drag one of the Amount(Sum) tokens (it's probably the second one) out of the Values box at the bottom. Then click in the Pivot Table and in the menu go to Organize > Refresh Pivot Table.

To familiarize yourself more with Pivot Tables you might want to have a look at the Pivot Tables Basics table at File > New in your menu. It has a working example and a practice area.

SG

Reply

Answer 2

Barry

Level 9

60,023 points

Apr 8, 2023 11:21 PM in response to Gerald Malis

I've had little experience with pivot tables in Numbers, so ths is an obervation rather than a recommendation.

You might try giving the 'grand total' columns of your source table a name that is different from the name of the monthly columns.

Regards,

Barry

Reply

Numbers pivot table hide certain columns

Similar questions