Pivot table functions

  • Thread starter Thread starter Dale Kolls
  • Start date Start date
Dale,

If you mean that you want a count of each grouped item (instead of the usual
SUM), yes. If XL2002, double-click the title for the data item (upper left
of pivot table) and change from SUM to COUNT or COUNTA. If in XL97, go to
step three of the wizard, double-click the item in the data area, and change
similarly.
 
That will give me the number of all the items, but what I
need is the number of unique items.
Make any more sense?
 
You could use a helper column in your original data:

=if(countif($a$2:a2,a2)>1,0,1)

and drag down.

The first occurence will get a 1 and the subsequent will get 0's.

Then include that in your pivottable.
 
Dale,

You could try using a Caclculated Field within your pivot
table. This gives you a new measure (data field) built
using a custom formula that can reference the existing
dimensions (fields) within the pivt table.

Gabhan Berry
AI Prediction and Forecasting in Excel
http://www.pececillo.com
 
Dale,

Oh. Well, why didn't you say so? :)

Then try this:

=SUM(N(FREQUENCY(A:A,A:A)>0))
 

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

Pivot Table with Data Model Connection - getpivotdata reference issue 0
Average of Subtotals in Pivot Table 0
Link Drop Down with Pivot Table 2
Pivot Tables 1
Pivot Tables by Macro 2
Pivot Table Defaults 1
grouping dates in a pivot table 1
Pivot Table Unique Cnts 1

Back
Top