2 of 2 people found this helpful
You can create a calculated field, with the formula measure1 + measure2 + measure3. you can also add different aggregation functions for each: sum(measure1) + avg(measure2) + count(measure3).
You can also have the same measure twice: sum(measure1) + avg(measure2) + count(measure1).
HTH. If not, can you please upload your workbook and clarify?
Please upload sample workbook.
After looking at your data, I see that the only difference between the sheets is the sets the sheets are filtered on (summing "coeffiecnts" by "type sub catgeory").
Furthermore, I see the sets are all originating from one column ("type sub category"), and that you have also a column ("type category"), which defines the sets.
In this case, I urge you not to use sets, but to filter by "type category" column.
Then, you will be able to create another sheet which sums the "coeffiecnts", and filters by "type category" = "carrier", "class".
I'll attach a workbook shortly. Please note, it will be for version 10 of Tableau, you can download and install it in the meantime.
Created a new worksheet summing the requested worksheets.
Added it to the dashboard.
Applied "class" and "type of carrier" filters for all relevant worksheets.
Book1.twbx 126.5 KB
THANK YOU SOO MUCH