I need to show the top n based on the grand total.
Create a calculated field.
Put this to filter and compute using as
Thank you for this but I also need the Order Date to see the history.
Something that looks like the below.
Here is the updated approach. I created a parameter.
Created a calculated field.
Place customer name to filters > Top, specify
Let me know if this helps.
This is actually great however it doesn't get the correct values for some reason.
On your screenshot, the 5th vendor is Adrian Barton but it should be Ken Lonsdale.
Just add order date filter to context.
If that helps, please mark the answer as correct and helpful.
Retrieving data ...