Count Unique using Pivot Table

B

bbishop222

I have underlying data that looks like this:

Region Cust # Creat Yr Sl Year Month Sales
MW 100 2007 2007 5 $500
MW 100 2007 2007 12 $700
MW 101 2005 2005 1 $100

What I want to get to in my pivot is a count of new customers by region:

Region Create Yr Sales Yr
2005 2007
MW 2005 1 0
MW 2007 0 1

I saw the posts referencing http://www.contextures.com/xlPivot07.html#Unique
however, the underlying data is coming from a non-Excel source.

Is there anyway to obtain these results in a pivot without creating an
additional column in the underlying data.

Thank you,
Beth
 

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

Using 'The count of' column in a pivot table formula 0
Calculated Item causes undue repitition in pivot table 2
Unique values in pivot 1
Creating a pivot table which resembles a SQL 'group by' 2
Column Heading on each row in pivot table 1
pivot table 0
Pivot Table Calculated Field 0
Subtract colums in pivot table 0

Top