Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In a chart expression I select the quarter to which the SELECTED month belongs:
=QuarterName(MakeDate(KPIYear,KPIMonth))
Will give me the quarter name in a column - I now need to calcuate the amount -
sum({$<KPIMonth=, Quarter={'Jul-Sep 2014'} >} TRPActual)
Works OK, but I need the 'Jul-Sep 2014' to be dynamic, based on the selected year and month (KPI...).
What is the correct syntax for the set analysis statement?
Many thanks,
M.
try this and let me know
sum({$<KPIMonth=, Quarter={'$(=QuarterName(MakeDate(KPIYear,KPIMonth)))'} >} TRPActual)
try this and let me know
sum({$<KPIMonth=, Quarter={'$(=QuarterName(MakeDate(KPIYear,KPIMonth)))'} >} TRPActual)
Brilliant!
I had missed the quotes around the dollar expansion.
Many thanks!
M.
Hi,
You can make a variable like
v_quarter=QuarterName(MakeDate(KPIYear,KPIMonth))
and use that variable in set analysis which is as follows :
sum({<$(v_quarter)={"*"}>}TRPActual)
Hope it helps.
Thanks,
Geeta