Please post a sample workbook
I have updated the post with a sample workbook in which i am using tableau sample superstore data only.
To get 10 Top/Bottom customer for selected region,
you have to add region as context filter.
Check attached workbook.
Hope that help you.
Gatik.twbx 1.2 MB
3 of 3 people found this helpful
Place the region in filter and select context filter.
Now we can get top 10 in each region.
Further to above, is there a way to 'Apply to Context', whilst not having that filter impact other measures i'm adding to my report? for example, i'm building a list of top 10 customers for a specific date range (MTD or Previous Month), which gives me the correct result if I add that filter and 'Apply to Context', however, i'm now unable to add additional data, such as YTD figures next to the MTD or Previous Month figures as the date range filter is applied across the board.
Alternatively, I can 'Remove from Context' and other calculated measures such as YTD etc work just fine (this now gives me correct measures however, the top 10 list is incorrect as it's taking full date range for the entire data and not filtered range). They just don't work together which is what i need.
Appreciate any help i can get.