Can you share the workbook?
I will not be able to share my twbx file though data structure is same as we have in Super store data, just I need to find top 5 subcategories with in each region for sales and their correct sub totals and grand total.
I hope this will give you an idea of the problem.
1 of 1 people found this helpful
Hey Joe, Can you please help me getting it corrected out.
I was trying to follow you blog on subtotals but I am unable to achieve the results, see If you can help me.
Thx Joe for replying so fast, you being an amazing ambassador for the tool.
I have 10.1 so your workbook is not opening as it's in 10.2.
I want Region and Product Name in the view and want to see top 5 product names with in each region with their Subtotals and final grand total.
I was able to calculate dynamically top n based on sales but when I am enabling the subtotals it's showing me subtotal for all the products in the particular region though it's displaying the Top N products.