can you please provide some sample workbook to understand your scenario.
Currently i am not able to provide work sheet due to some restrictions.
I will try to explain here.
Total1 from work sheet1 view
Total2 from work sheet2 view
I want to display Total1 + Total2 from two views in dasboard as Final Total = Total1+ Total2
Final Total = Total1 + Total2
It is not clear, use dummy data and try to explain.
Please find the below sample data
Worksheet1 view Retailer Level :- retailer Geo Class Trade Class sales % of total Retaieler1 3 A 13.5 13.99 Retaieler2 1 B 12.5 12.95 Retaieler3 2 C 11.5 11.92 Retaieler4 1 A 10.5 10.88 Retaieler5 2 B 10 10.36 Retaieler6 3 C 9.5 9.84 Retaieler7 1 A 9 9.33 Retaieler8 3 B 7.5 7.77 Retaieler9 2 C 6.5 6.74 Retaieler10 3 A 6 6.22 96.5 Total1 100.00 Worksheet2 view Trade Class Level Trade Class Sales %of Total A 33 34.20 B 22.5 23.32 C 21 21.76 Toatl2 79.27
I am using Both Views in DashBoard Final Total = 179.27 Required to present Totals from both views in dashboard
You'll need to union your two data sources together. In a tool like Excel that uses cell references we can use the results from cells on one worksheet in another worksheet, in Tableau each worksheet is roughly*** independent of the others.
*** We can set up filters that cross worksheets and in dashboards Highlight Actions and Filter Actions that cross worksheets.