Hi,

I have a small Excel database with the following columns:

A) Transaction Date (TD)
B) Status (can be either Complete, Dead, or Pending)
C) Commitment Fee (CF)
D) Administration Fee (AF)
E) Downpayment Fee (DF)
F) Legal Fee (LF)

I have created a small pivot table.

Along the row: Status
Along the column: Transaction Date

Data: Commitment Fee, Admin Fee, Downpayment Fee, and Legal Fee

I have further grouped Transaction Date into quarters and years.

I have added to the "Years" the Sum by using Field Settings. So now I have
the sum of each of the fees per year.

My question is, how can I get the Grand Total for all the fees per year?

Any advice is most appreciated.

Kevin