Is there way to show previous month sales and this month sales in a straight table , without using the below() function
The table Structure I am trying to create is and the used measure
Year Month
Revenue --> Sum(amount)
Revenue Previous Month --> below(sum(amount))
2020-04
1000
800
2020-03
800
500
2020-02
500
-
Is there way to get to this result without the below function. The reason is that sorting is not preserved in Qlik Sense Alert (SaaS ) and the below results get changed because of that.
On another note , is there a way to sort the alert columns in Qlik SaaS ( I was not able to find that option)