5 Replies Latest reply on Feb 23, 2017 7:38 AM by Jonathan Drummey

# sum of fields in dashbaord

Hi,

I have Total in two work sheets.I want to display two total sum two Total sums from different sheets need to display in dashboard.

Ex: Total1 + Total2 = Final Total (Final Total in Dashbaord)

Please suggest me how can i achive this.

Thanks

• ###### 1. Re: sum of fields in dashbaord

Hi Raj,

Thanks,

Sreekanth.

• ###### 2. Re: sum of fields in dashbaord

Hi Sreekanth,

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

Thanks

• ###### 3. Re: sum of fields in dashbaord

Hi Raj,

It is not clear, use dummy data and try to explain.

Regards

BH

• ###### 4. Re: sum of fields in dashbaord

Hi,

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 Dashboard I am using Both Views in DashBoard Final Total = 179.27 Required to present Totals from both views in dashboard
• ###### 5. Re: sum of fields in dashbaord

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.