I want to know what is the best way to show changes in ranking from current YTD from last month's YTD. Please see below:
The left is current and right column is from previous month. On the third column, I want to show the change (+/-) in rank from previous month (e.g. gained 3 spots vs lost 3 spots) Do you guys know the best way to go about this? I would think you have to index the two columns..but kind of stuck. Unfortunately, I can't attach the workbook due to private data.
Create a calc for column1-Column2.
Then do RANK([that calc]) (which defaults to ascending. You can do RANK([that calc],'desc') to make a descending ranking.)
You might need to mess with TABLE(down) or some other table calc setting.