Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Grouping measures

Hi All,

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

 

Please find the data below : 

 

MonthNet SalesADCADEADROverall SalesADC StoreADE StoreADR Store
Jan100102030400030400200
Feb5001133556755500400350
Mar100102030400030400200
Apr5001133556755500400350

 

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 SalesADCADEADROverall SalesADC StoreADE StoreADR Store


Can someone please let me know how to achieve ?

Thanks Poojitha

Need Help

4 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

      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's avatar
        GilbertQ
        Super User
        5 years ago

        Hi Anonymous 

         

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