Form separate columns for the status

[Baavik]

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 !!

[Taoufiq_Zarra]

@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:

[Baavik]

@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 -