I want to be able to group information (no problem) but be able to show a completely different set of columns when the grouping icon ('+') is selected. For Instance, lets say the top level report is:
DEPARTMENT | MANAGER | BUDGET # | TOTAL SALES
Expand DEPARTMENT and get
MANAGERS | COST CENTER | NUM EMPLOYEES | Q1 SALES | Q2 SALES | Q3 SALES | Q4 SALES | ANNUAL TARGET
and so forth; there could be one or 2 more drill downs each with different columns. Is this possible? Thanks in advance.