This content has been marked as final.
Show 3 replies
-
1. Re: Compare rank between present month and previous month
Steve Taylor Aug 15, 2016 7:11 AM (in response to Natnicha Nanthadechawuth)Hello Natnicha
The way I've attempted this in the attached workbook is to create separate rank calculations for each month then subtract November's rank from December's.
I hope this helps.
Steve
-
Compare rank.twbx 1.1 MB
-
-
2. Re: Compare rank between present month and previous month
Steve Taylor Aug 15, 2016 7:19 AM (in response to Steve Taylor)2 of 2 people found this helpfuljust read your original post again, I fixed this to November and december but to get present month - previous month you'd need this for current month:
and this for previous:
NOTE they won't work with superstore data as that only goes to December 2014 and the TODAY() function will be the current date.
-
3. Re: Compare rank between present month and previous month
Natnicha Nanthadechawuth Aug 16, 2016 1:31 AM (in response to Steve Taylor)Thank you so much
your answers are really help.