Thanks for the response, would you please explain how you have done?
Seems you have removed the action filter from context, by doing so the soft order of the result sheet is not accurate.
the actual result is:
but the result tableau computing is;
When i add the action filter to context the sort is accurate
but some selections are showing blank.
I think the flaw is for the top products sheet , if you remove the product set out of the filter than it will wok fine.
PFA Screen and Workbook
thanks for the response
But the sort order of result sheet is not correct when you select month as "Jan"...cross check the top products of store "Walmart" for the month "Jan" with the actual data in attache excel.
Is different from result calculated in Tableau, but if we add action to context the sort order is correct.
The issue with sets are the filters are applied on the sheet but not to the actual set, that's why the action is not resulting correctly.