Calculate total of all the months in table

[Aspiring_Developer]

Hello All,

I have below table :-

I wish to show the total of all the months in single row .

For instance Oct 21 the sum (closed_wkg_days) should be (56+27+17+11+65+48+9+2+59+45+21+1+0+96+29+24+10+5).

My requirement is to show the sum of all values present in each month and show only one single record for that .

I am not able to figure out how to show all the values in single row. Can anyone please help ?

Thanks in advance

@Kushal_Chawda @sunny_talwar 

[justISO]

Hi, simply remove CATEGORY column of your table and you will see total sum by month like this:

or if you need to also see categories, you can create not simple table, but Pivot table, with dummy row for total total (expression:  ='total'), month, category, and measure for sum closed_wkg_days and you will see your data like this: