You can try below approach:
1. create a rank field: RANK(SUM(SALES)).
2. Change it to discrete and place it between region and product name.
3. Go to edit table calculation for "Rank" and do the below setting :
Change both date and region to context and you will get the below result.
For details explanation you can refer below link.
yes.but instead of order date,i have a date filter,which will have values like mtd ,ytd,wtd etc.Also I have some quick filters .
.Can you plz tell me how did you do this