I created a pivot table, need help to sum the counts....

[ShantanuDagar]

I have a pivot table created using a dataset which is showing count in 1 column.

I need 1 row at the end with name grand total which sums the count of that column.

ABC	56
PSP	88
wsw	333
asa	360
asasasa	56

Grand Total  893

Like this. Thanks

[FinnCharlton · Accepted solution]

Hi @ShantanuDagar , here is one way to do this:

There is also a macro you can download called 'Add Totals' which will do this sort of thing automatically for you. You can download it here: http://www.chaosreignswithin.com/p/macros.html

[ShantanuDagar]

Thanks, works perfect.