I have a requirement to apply dynamic column grouping to aggregated data.
The underlying dataset is a table that contains STORE NUMBER, REGION, VOLUME, SALES, FORECAST.
The initial presentation of the data will be as follows. The SALES and FORECAST data will be summed across the entire dataset with a count of total stores.
The users would then like to be apply dynamic grouping of the aggregated dataset without filtering out any of the underlying dataset. In this example, they’d want the options of grouping by data by (1) REGION, (2) VOLUME, or (3) REGION and VOLUME.
- Group by REGION
- Group by VOLUME
- Group by both REGION and VOLUME
I’ve attempted to use slicers for the selection of the groupings but that ends up filtering per selection as one would expect. Any help or direction on how to support the desired functionality would be much appreciated.