Grouping measures

[Anonymous]

Hi All,

I have a requirement where I need to group the measures and give a  header for it.

Please find the data below : 

Month	Net Sales	ADC	ADE	ADR	Overall Sales	ADC Store	ADE Store	ADR Store
Jan	100	10	20	30	4000	30	400	200
Feb	500	11	33	55	6755	500	400	350
Mar	100	10	20	30	4000	30	400	200
Apr	500	11	33	55	6755	500	400	350

Now I would like to group it as below with the headers with Totals and Store wise header:

I need to give a header as Totals for 4 of the measures and Store Wise for other 4 measures in the matrix visual.

Note :  the below are calculated measures which are derived in the report.

Net Sales

ADC

ADE

ADR

Overall Sales

ADC Store

ADE Store

ADR Store

Can someone please let me know how to achieve ?

Thanks Poojitha

[GilbertQ]

Hi @Anonymous 

All that I would do, is to put two text lables ontop of the table/matrix where it needs to show the right values. This would be a quick and easy way to accomplish this.

To try and do this via measures etc will involved a lot of work which use disconnected tables and you would then need to also create new measures for them to fall into place.

[Anonymous]

@GilbertQ  We tried to add text boxes on top of the table, but the problem comes when we scroll as there are several other measures to be grouped in similar fashion.

[GilbertQ]

Hi @Anonymous 

Then you could go with creating disconnected measures to get it all working!

[Anonymous]

For now, we have renamed the column names to include store wise and totals.