PIVOT TABLE HELP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

I need to know how i can insert a "Sum If" Function in the Pivot table. As
there are only standard formulas in the options and Excel does not allow me
to input custom formulas.
I have my table as follows:
Bank Currency Amount Status
A USD 1 Pending
B USD 5 Pending
C EUR 6 Pending
A GBP 2 Renewed
B USD 6 Renewd
C GBP 7 Pending

When I choose the Pivot table I am able to give my criteria for bankwise and
for each type of currency to sum the amounts, But I am unable to give a sum
if function on Pending ones only...
Hope u guys can help me on this.
Imran.
 
You could put the Status field in the Column area.
Then, click the dropdown arrow on the Status field button, and remove
the check mark from Renewed.
The pivot table will show only the Pending amounts.
 
Back
Top