I don't think there is a way to selectively remove subtotals from some fields, but there may be a workaround. You can create two sheets, one with fields that need subtotals, the other - with fields that don't, and join them on a dashboard. This will require some alignment 'acrobatics', but it may work.
Thank You Dimitri.
I really thought it was possible. After all it must be a very common issue faced by users. Don't think I can afford the effort required to apply your workaround to the many tables affected by this issue but I do appreciate your help though!
Hopefully, Tableau 7 will be more clever in this area.
There are a few different ways to craft a setup to detect when in a grand total or not, and provide a different value, eg, SUM([Field]) for the rows, and Null in the grand total for a blank space, or even some other calculation at a different level. There are lots of possibilities. attached is an example.
null_in_gt.twbx 246.4 KB
I knew there was a better workaround! Granted, it involves table calculations, some rocket science and a bit of black magic, but it does the job, and does it well.
It would be great if Tableau incorporated it as configuration options in each field, i.e. 'Do not show grand total' and the ability to specify what aggregation to do in grand total, i.e. SUM, AVG, etc., so people don't have to learn voodoo to accomplish this.
Saved for future reference.
Thank You Joe. Impressive as usual.
Not having your level of expertise, your workaround does look like black magic to me though ;)
Completely agree with Dimitri on the opportunity for Tableau to incorporate custom aggregation by column/row.
This is after all a very basic feature covered by most other BI tools in the market.
Tableau 7 may be...
I just ran into this exact same issue. One of the fields is a Percent... and a Grand Total of a Percent doesn't make sense most of the time.
Tableau 8 maybe...