I have a table view which has totals, subtotal when we click on the total or subtotal it wont filter the detail data. can we disable this drilldown action only for totals, subtotals?
#Tableau Desktop & Web Authoring
,
There is not a native toggle to exclude only the Grand Total / Subtotal marks from a filter (drill) action, the action fires on any mark the user clicks, and a total mark carries no single dimension value, so clicking it either filters to nothing or does nothing useful.
The practical ways to handle it:
Set the filter action to run on Menu instead of Select (Dashboard, Actions, open your action, Run action on: Menu). Then a click does not auto-trigger; the user only drills when they choose the link, which avoids the dead click on a total.
If you need clicks to keep working for real rows but not for totals, handle it on the target sheet: add a condition or filter so that when the passed value is null (which is what a total sends), it shows the full/normal result instead of an empty one.
Alternatively, if the totals are only there for display, consider showing them in a small separate summary sheet rather than on the interactive table, so the interactive table only contains drillable rows.
There is no "totals are not clickable" switch today, so if that is what you would really like, it is a reasonable IdeaExchange request.
