how to calculate sum of list values in single column in Tableau

135 Views Asked by At

I have to calculate sum of CCA + Exgratia + Gratuity+ HRA + LTA + Medical

but these values are stores in single column "Allow amt" for all Employees

and Allow Desc contains CCA , Exgratia , etc,..

https://i.stack.imgur.com/OwAEt.png

1

There are 1 best solutions below

0
Siva On

one way is to take the row sum by going to Analysis menu and 'Totals -> Show row grand total'. One more way is to take sum of the values in another sheet and combine those in a dashboard.