Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have 2 different dimension:
- MonthYear
- SurgeryMonthYear
I would like to select in my report the MonthYearServices based on the MonthYear selection. So just selection on MonthYear should be done. Is something possible?
I'm using this formula but is not working
=Sum({<SurgeryMonthYear={$(=concat(chr(39) & MonthYear & chr(39),',') },MonthYear=,Day=,Year=,Month=,Quarter=>}WI_EUR)
Can anyone please advise?
Thank you
May be this
=Sum({<SurgeryMonthYear = p(MonthYear), MonthYear, Day, Year, Month, Quarter>}WI_EUR)