if you apply filter on subcategory and select all then it will show total value as per your calculation. But when you select furniture or specific value from dimension then it will give you desired output as per calculation.
Just let me know how you want to show the data and what should be the final output as you want to see as result.
Hello, seraj alam!
Thank you for responding.
I want the grand total to be the sum of each individual row whereas now it is simply the ELSE statement, total sales times the final percentage. I opened the workbook you attached and I cannot see the change. Could you show me how to get the totals to be equal to the sum of the rows?