Retaining Subtotals and Percents on Pivot (Hide/Remove Dimensions)

[ttwward]

How can I make the pivot to retain is values when one or more dimensions are removed/hidden?

How can I hide a dimension on a pivot table?

I have a pivot with Dimensions (CycleDate, Role, Status, ActiveFlag) and

Expressions

Count of records = COUNT(REC_ID)

Percent of Active records = count(REC_ID)/count(all<CYCLE_DATE,ROLE,STATUS,ACTIVE_FLAG>(REC_ID))count(REC_ID)/count(all<CYCLE_DATE,ROLE,STATUS,ACTIVE_FLAG>(REC_ID))

and

Total Records by SubGroup = count(all<ROLE,STATUS,CYCLE_DATE, REC_OWNER>(REC_ID))

How can I remove/hide role,status and ActiveFlag without changing the subtotals and pecent values?

[Oleg_Troyansky]

You can't hide or remove dimensions in a pivot table. You can only "collapse" or "expand" dimensions, using Pivoting functionality. Collapsing dimensions will keep the totals at the level that's being displayed - in your case, if you collapse the last 3 dimensions, you'll have the totals by CycleDate.

Hope it helps,

Oleg