Forum Discussion

kdixon5490's avatar
kdixon5490
Helper III
3 years ago
Solved

Grouping Measures

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,