Have you tested this within the browser to see if you get the same result?
The highlighting in the toolbar is something different entirely, so won't have any impact. The highlight you are seeing is just the selection of that tab/workbook in the dashboard.
I would be curious to know if it works properly in a web environment.
Yes I have tested with three browsers, Firefox, Chrome and IE 9 and yes, it works the same in all three that it does on the desk top. The highlighting is not what bothers me ( and the client) so much. But the double click to run the action will cause major heartburn.
Nope, I see the problem in your workbook but I think they're gonna have to put up with the double click, as long as you're using this method. It seems to me that the first click is to select that worksheet, then a click provides your desired action.
What I can tell you is that you could include both on one dashboard rather easily--you could also create a parameter control to switch between profits and expenses.
If you'd like someone to mock that up, we'd be glad to help. I think the less "tabs", or worksheets, the better. You could accomplish your goal in one sheet, using a parameter.
Went ahead and did this using a Parameter--see attached. This is multi-step process:
-Created parameter control using list of Strings--possible choices "Profit" and "Expenses"
-Created calculated field (when using parameters, a Calculated Field is ALWAYS required to leverage the parameter control) named "Profit or Expense?" This is a case statement that provides Sum(Profit) or Sum([Total Expenses]) based on what is selected.
-Replace Sum(Profit) pill on Rows Shelf with the newly created Calculated Field named Profit or Expense?
-Added parameter control to Dashboard 1--eliminated all other sheets/dashboards
I hope this helps! This is a very useful feature of Tableau, and one I highly recommend you familiarize yourself with! You could add as many more measures as you'd like to this parameter, and this eliminates re-creating the same charts over and over with different measures.
Best of luck!
Profit Expenses Parameter.twbx.zip 328.0 KB