Any way of using "Countif" functionality in a Pivot Table?

[chris.slater]

Hi All
I have a need to use a condition similar to Countif in a Pivot Table.
The data is sourced via an external ODBC link and it concerns Sales Data.
I want to be able to report on Closed Sales by Advertising Medium.
The source data has the individual sales leads along with their Advertising Medium listed in each row. In addition the Status of the lead is also listed ie "Won", "Lost", "Open" etc.
What I need my Pivot Table to do is show the Advertising Medium as the Row Label in Column A and then show various values relating to each.

Source.of.Sales........................Leads................%...........Sale.Qty...........Sale.Conv..............Sales.Total.Value
Dropcard-Construction..................316............2.67%...............314...................99%.......................£50970.00
Dropcard-Interiors......................1972...........16.67%...............803...................41%....................£205,412.00
Internet.....................................735.............6.21%...............101...................14%....................£535,213.00
Lancashire.Life...............................1..............0.01%..................1.................100%........................£2500.00
Manchester.Evening.News................3..............0.03%..................3.................100%......................£12500.00


"Leads" is easy enough as it's a simple count of the total as is the "%" column just displayed as a percentage, the difficult part is "Sale Qty" and "Sales Total Value" because they are conditional on the Status Field in the source data having a value of "Won".

I'm hoping that there is some way of creating a calculated field that counts all of the leads for each of the Advertising Medium types that have a value of "Won", like a "Countif" formula would do. The problem is that I can't seem to find a way of doing it with a Pivot Table field and I can't insert a normal column into the middle of the Pivot Table to perform a standard "Countif" function.
Any help gratefully received.

[oeldere]

IF so, then it will be on:

Options => formula => counted fields.

Otherwise you have to make a column in the table and make an new pivot table.