Conditional Grouping or Aggregating the data

[Naven]

Hi,

I have to a list report with conditional display of columns i.e. column selection happens in the prompt page.

So when all the columns are chosen to appear in the report page, data is displayed at detail level which is fine.

If I select few columns or exclude some columns from selection,still data is displayed at detail level which I can understand(box type none but at the back, columns are present) . I need to display aggregated data at the particular level based on the columns selection.

Consider a scenario where I have 3 columns Geography, Quarter and Total Billing.

When all the columns are selected data is displayed at detail level i.e. billing for each quarter in a geography.

My requirement is when I select only quarter and Total Billing, aggregated data at quarter level(only 4 quarters for all geographies) has to be displayed not repetative quarter data for all the geographies.

Please guide...

Thanks,
Naveen

[MFGF]

Hi,

You probably need multiple lists for this, then conditionally show or hide the appropriate list.

MF.