How to get pivot rows total in single column which must be part of pivot

[Ratan Bhushan]

Hi Team

I have attached a file where I have collated data in pivot month wise. in the last column, I want another column to be added in pivot showing total of rows so that the data can be sorted on that total basis.

Please help

Thanks
RatanB

 

[Hui]

Right Click anywhere in the PT
Select PT options
Select Totals & Filters tab
Select Show Grand Totals for Rows

 

[Ratan Bhushan]

Right Click anywhere in the PT
Select PT options
Select Totals & Filters tab
Select Show Grand Totals for Rows

Sir
I have been doing this but this is giving me total in separated columns

What I want is I want Total Count showing in one column -

 

[Hui]

Just add a column at the end with a formula in it
=sum(N6: P6) or similar

 

[Ratan Bhushan]

Just add a column at the end with a formula in it
=sum(N6: P6) or similar

Sir

Please advise, can we do this thing pivot, so every time when data gets refreshed, its automatically updated