PIVOT TABLE HELP

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.
 
D

Debra Dalgleish

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If statement for equivalent value of a range 4
Pivot table calculated field Count(field) / sum(field) 0
Calc on Pivot Table 1
List of currency codes - are they are all the same? 2
creating pivot from a horizontal table 4
Pivot Table Help! 1
Multiple variable lookup tables 3
Exporting specific rows in another Sheet 8

Top