Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
I want to create QTD (Quarter Till Date) and PQTD(Previous Quarter Till Date)
directly from Quarter field as Dates not been provided in the applicatin,
The Format for Quarter field is YYYYQ1 eg 201601 Please help me with the variable and expression that I should create.
May be this:
Sum({<Quarter = {"$(=Max(Quarter))"}>} Measure)
and for previous quarter
Sum({<Quarter = {"$(=Max(Quarter, 2))"}>} Measure)