1 of 1 people found this helpful
You will want to create a RANK table calc that you'll specify to compute for each month. It will assign a value of 1-through-N for the customers by month, and then you can use that to filter for values less than 6.
If you need help with this, I'll need a workbook to show you.
Good morning Casey
see the attached superstore example
as I read your problem you wanted the top 5 customers each month
one way is to use Rank and LOD
then the filter is hard coded to 5 - it could be a parameter that you could change
set like this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
top 5.twbx 2.4 MB
Thank you, this is very helpful!
Glad to help out