While there are plenty of discussions surrounding Top N analysis, I wasn’t able to find a solution that fit my issue exactly.
I have a trended chart by month where my goal is to sum up the total billings for the Top N products (grey bar) per month and compare it to a total (this is blended from another data source - but not important for this case).
I need to sum up the Top N product Billings per month without adding the product ID into the detail / calculating the rank. Here is what I’ve tried so far:
Thanks for any help in advance!
If I am getting your question, how about ranking the products based on billings per month and then computing the rank using month? This will take care of the ranking across the data set issue.
Do you have a sample workbook to share?