I have a dashboard which has a table. The table has several metrics and a 2 level hierarchy for the dimensions: Region and State. The Regions have sub-totals in the table. There are filter actions set up on the table so that clicking on a Region or State name will filter the rest of the dashboard by that Region or State. Works great, the problem is that if you click on the Region subtotal line it clears all the filters, where I would expect it to filter by Region. It behaves the same in 6.1 and 7, desktop and server.
Is this the way it is supposed to work, and is there any way around it?
This is currently how actions are setup to work when clicking on subtotals. The way around this would be to click on the portion of the view that it was a subtotal for--i.e. click on the specific Region to get the subtotal.
To change the functionality, perhaps post this under the Ideas section of the community!