The above mentioned is possible through sets.. But say total sales is 1000 and top 3 sub categories put together have sale value of 300.. I want a calculation where i can subtract 1000-300. How can i do this ?
Please create a workbook with Superstore and attach here to get help faster.
Total Sales is 12642502.. Top 3 sb categories contribute 637209 and rest 830248. Now i want to Subtract TOTAL SALES - TOP 3 SUB CATEGORIES SALES
I used an alternative approach. Please follow attached.
If it Helps, pl mark it Helpful and CORRECT to close Thread
Retrieving data ...