Forum Discussion
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,
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
2 Replies
- amitchandakSuper User
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
- kdixon5490Helper III
Thank you very much!