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
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))
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?
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,