Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Team,
In the rolling3months.qvw , how can I compare the sum(amount) for rolling 3 months at each month with set analysis and do some classification logic accordingly .
example>Month 3 is selected than last 3 months including selected month is to be compared for sum(amount) and create a new colmumn named"classification"" which will from below logic.
High-->if last 2 months sum(amount) greater than 4
Low--> if last 3 months sum(amount) less than 4
Standard-- if last 3 months sum(amount) equals 4.
In this case Month 3 will be marked accordingly (either High or Low or Standard).
Dear team,
Can you please suggest?