I wanted to show top/bottom 5 zones of total business based on the difference of business as on date and business on last FY.
While calculating the difference I had used sum(by_group) in it and named the variable 'X'.
The variable 'X' is not showing in rank , this is the problem.
Can anyone please guide me on an alternative?
Thanks!