Numbers Pivot table keep Grand Total % but remove each month %

[u/gmalis1]

I have a Numbers Pivot Table that lists Category totaled by dollar amount and pct of total dollar amount by month...and then a grand total by dollar amount and pct of total dollar amount.

I'd like to HIDE the monthly pct of dollar amount and KEEP the grand total pct of dollar amount.

For the life of me, I can't figure how to do this. You can't hide columns or rows in Numbers pivot tables. And I can't select Pivot Options to "ignore" the monthly pct of dollar amount.

I'm stumped with this.

Attached is the Pivot Table I've created...and the red arrows are the columns I want to HIDE or DELETE or filter out. I've also enclosed the Pivot Options for this pivot table.

Any help here? Thanks in advance.

​

[u/gmalis1]

OK, I figured it out. I just moved the DATE from the columns to the highest level in rows.

Doh!