Grouping Measures

[kdixon5490]

HELP!!

I have 3 Date parameters on my report.  Let's call them Date_A, Date_B and Date_C.

I also have 3 Area of Interest (Revenue, Admission and Per Cap).

Then I have a Date Value, MTD, YTD

Image The Below.   All of these are created by Measures.

Revenue

     DATE_A

           Date Range

           MTD

            YTD

     Date_B

           Date Range

           MTD

            YTD

     Date_C

           Date Range

           MTD

            YTD

Admission

     DATE_A

           Date Range

           MTD

            YTD

     Date_B

           Date Range

           MTD

            YTD

     Date_C

           Date Range

           MTD

            YTD

Per Cap

     DATE_A

           Date Range

           MTD

            YTD

     Date_B

           Date Range

           MTD

            YTD

     Date_C

           Date Range

           MTD

            YTD

I need the ability to Show 3 bars graphs 1 for REvenue, 1 for Admission, and 1 for Per cap.

Then inside the graph I need to group like the below.  I've created all the data thru Measures.

Example for Revenue ONLY.  

Thanks,

[kdixon5490]

Thank you very much!

[amitchandak · Accepted solution]

@kdixon5490 , check the layout i discussed in this video, one should match with yours

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0