Hi,



Is there anyway i can get a sum for "A Total" in my pivot for all the month Jan, Feb & Mar

I am pasting a sample data & Pivot.

Pivot

Count of S Num
Status Name Jan Feb Mar Total
A John 1 1 1 1
Peter 1 1 1 1
A Total 2
B Tom 1 1 1 1
David 1 1 1 1
B Total 2
C Jack 1 1 1 1
C Total 1
D Harry 1 1 1 1
D Total 1
Grand Total 6

Data
Name Status Count S Num Jan Feb Mar
John A 1 4194 1 1 1
Tom B 1 4791 1 1 1
Jack C 1 4982 1 1 1
Harry D 1 1980 1 1 1
Peter A 1 1280 1 1 1
David B 1 2819 1 1 1

Hi,
your data structure is difficult to understand.
Could you please attach a sample excel sheet with your data.

Kind regards
Bjorn