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,..
Asked
Active
Viewed 121 times
-1
-
show sample data,how can anyone know what are you trying to do? – Siva Oct 19 '18 at 10:25
-
Here is the my sample data https://i.stack.imgur.com/OwAEt.png – Ravichand Oct 19 '18 at 11:56
1 Answers
0
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.
Siva
- 9,043
- 12
- 40
- 63