Forum Discussion
Drilldown with calculationgroups and time
Hello folks,
I am trying to achieve the following: I have a calculation group with e.g. 2 calculation items, Sales and Sales LY.
This is displayed in a matrix in columns, which also have time information, like in the picture below.
Now I want to have the two calculation items always next to each other, regardless of what "drill-down" status I am (Year, Quarter, Month), so you can compare them better. How can I achive this?
| currently | wanted | |||||||
| Sales | Sales LY | Q1 | Q2 | |||||
| Q1 | Q2 | Q1 | Q2 | Sales | Sales LY | Sales | Sales LY | |
Thanks in advance
2 Replies
hashtag_pete , You need use a calculation group for this: Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
Hello amitchandak
thanks for this video, it's really interesting!However, it's not really solving my problem. What I want is to have the possibility to drill down in time, but always have the selectedmeasure of my calculation group next to each other. So whatever Time Drill Down I have, I can always compare the values.
2022 2022 2022
Sales Sales LY Q1 Q1 Sales Sales LY Jan Feb Sales Sales LY Sales Sales LY
