4 Replies Latest reply on Mar 21, 2014 2:28 PM by Jonathan Drummey

# How to calculate subtotals based on the Dealer Name? I used Index function to get the Top 10 Dealers. But when I use the Subtotal and Grand Total on Dealer, I see both of them are giving the same value. Any help is greatly appreciated. Thanks!

How to calculate subtotals based on the Dealer Name? I used Index function to get the Top 10 Dealers. But when I use the Subtotal and Grand Total function, I see both of them are giving the same value. Any help is greatly appreciated. Thanks!

• ###### 1. Re: How to calculate subtotals based on the Dealer Name? I used Index function to get the Top 10 Dealers. But when I use the Subtotal and Grand Total on Dealer, I see both of them are giving the same value. Any help is greatly appreciated. Thanks!

Hi Shiva

Can you post your workbook with the sample data and attach here Or a Snapshot of it would help us to understand it better.

Thanks

Karthik

• ###### 2. Re: How to calculate subtotals based on the Dealer Name? I used Index function to get the Top 10 Dealers. But when I use the Subtotal and Grand Total on Dealer, I see both of them are giving the same value. Any help is greatly appreciated. Thanks!

Tableau's totals and subtotals are calculated in a different path from the main part of the view, and table calculation filters (such as those using INDEX()) are not applied to totals and subtotals. There are techniques where you can increase the level of detail in the totals and subtotals and then build the Top N filter into the calculation to get the desired results, but they are extremely dependent on the view. I suggest you post a packaged workbook with some sample data.

Jonathan

• ###### 3. Re: How to calculate subtotals based on the Dealer Name? I used Index function to get the Top 10 Dealers. But when I use the Subtotal and Grand Total on Dealer, I see both of them are giving the same value. Any help is greatly appreciated. Thanks!

Thanks Jonathan for the response. Can you please post the techniques where i can increase the level of details.. I can not send you the packaged workbook due to settings managed by Administrator.

Thanks

• ###### 4. Re: How to calculate subtotals based on the Dealer Name? I used Index function to get the Top 10 Dealers. But when I use the Subtotal and Grand Total on Dealer, I see both of them are giving the same value. Any help is greatly appreciated. Thanks!

See http://drawingwithnumbers.artisart.org/customizing-grand-totals-part-2/. You will need to have a familiarity with table calculations.

If this is not enough, then you'll need to take some time to mock up some data and put it into a workbook.

Jonathan