Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the data of 3 month end sales with vMaxDate as today and vMonthEndMinus1 as last month data.
Now by comparing Jan, Feb, Mar sales-
if all the 3 values are same - status is 'Same'
if current sales > previous sales - 'Improve'
if current sales < previous sales -'Deteriorate'
The expected output is , 3 separate columns are needed for each status with total count of Status.
Need help in the logic to form separate columns in back end. Thanks !!
@Baavik if I understood correctly
from this input :
you can add table or chart and ;
dimension : Product
measure 1 : Count(If(Status = 'Improve', [staff id])) -> Improve in the name
measure 2: Count(If(Status = 'Worsen', [staff id]))-> Worsen in the name
measure 3: Count(If(Status = 'Stable', [staff id])) -> Stable in name
the output:
@Taoufiq_Zarra - Thanks for this!!
But I need to get the status column based on the comparison of selected months data.
User wants to select any 2 random months from the Month filters and compare data in the same table as below -