You can create a new worksheet to act as your legend. When you click on this worksheet you can have a dashboard highlight action to the scatter plot and a filter action to your summary.
But then it only highlights the values in the newly created table. I want the table to aggregate the highlighted values to a total.
It's all possible Julian. If you can attach a workbook showing the problem and the expected output, you'll get an answer. Use superstore to mock it up if you can't share.
Jumping on a plane. If no one else looks at this, I will later.
1 of 1 people found this helpful
You would like to see aggregated numbers for the marks selected in the scatter plot, correct?
I did this with three steps:
1. I added a grand totals row to Sheet 3 (your table sheet) under Analysis/Totals/Show Column Grand Totals)
2. I told Tableau to use Average for the grand totals (under Analysis/Totals/Total All Using)
3. I removed the Highlight actions and instead used a Filter action that triggers on select.
The net result is that when you select marks in the scatter plot, it filters the data in the table and then Tableau calculates column averages for the (now filtered) data.
Is this what you were looking for? If not, let me know and we'll get you unstuck.
I do not want to show averages. I want totals of only my selected (could be several) in a own field. I do not need to see every single value in the table, I only want to see the total sum. You know like in excel in corner to the right when you mark cells. DO you follow me?
3 of 3 people found this helpful
You can do this multiple ways. Here is one.
Float the Sheet 3 Totals on top of the scatter plot. I ditched the customer detail so this is just sum(order quantity) and avg(discount). You can setup whatever aggregates you want to see.
Change the Filter Action so only sheet 2 filters sheet 3
Now the Grand Totals will update no matter what you select in your scatter plot
I don't have whatever version you are using with me and you didn't say so attached is a 9.1 version. You can hack it to whatever version you are using.