Hi Avvy, Thanks for your info, but it DOESN'T work, as what we have experimented before. I followed your instruction but the result is shown as below. It seems that if "Quarter" is the "category" and "Sales ID" is the "group category", and then use "rank" on "sales ID" by a measure, it will only show the same top 3 sales ID with their measure in each quarter, that's not the way we hope it to present every top 3 sales ID in each quarter (failed to attach the screen capture). Any other way to do that? Best Regards, Teresa
... View more