Count Function in Pivot Tables

[Shwatta]

Hi,

I have a spreadsheet full of sales data, I would like to create a pivot table that will count a certain sales outcome for a given sales medium.

I made a cast of what I mean -
>> http://screencast.com/t/ZThlOTE5ODQ

Any ideas, I would great appreciate it.

Thanks

 

[Peter_SSs]

Welcome to the Mrexcel board!

From what I can see you are almost done. Just drag the 'Sale Status' again from the Pivot Table Field List and drop it in 'Drop Data Items Here'.

For the future, it helps if you can post small screen shots with sample data directly here in the forum. Here are a few ways to investigate.

Excel jeanie
or
RichardSchollar’s beta HTML Maker
or
Borders-Copy-Paste

 

[Shwatta]

Thanks problem solved.

Pivot tables are going to save me a lot of time!