Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I have two master item measures using set expressions to calculate previous ytd membership vs current year to date membership. I want to present these (and other similar YoY metrics) in a pivot table under the applicable year. When placing my Year in the dimensions and my individual PYTD and CYTD master items in the measures it shows each column under each year. I want to show only Previous YTD MMOS under 2022 and Current YTD MMOS under 2023.
Any help is appreciated!!
image of table attached for reference
could you try something like, if (year(your_PYTD_date) =2022, pytd, cytd)
(you can make this dynamic by using year(today())-1) instead of 2022.
Default pivot won't allow you to do that. Maybe you can try some extensions.
Regards,
Aditya