Excel 2007 PivotTables

  • Thread starter Thread starter David Keren
  • Start date Start date
D

David Keren

I have a Pivot Table that references an input Excel file which
includes 3 columns:
CustomerName
StoreID
Purchase
I have dragged the StoreID to the "Row Lables", the CustomerName to
"Row Lables", the CustomerName to "Values", and Purchase to "Values".
As a result, my Pivot Table displays lines of purchases grouoped into
Stores (StoreID).
I would like to have an extra column in the Pivot Table which shows
how many lines are grouped in each StoreID group.
Can anybody help me with that?

Thanks,
David
 
I have a Pivot Table that references an input Excel file which
includes 3 columns:
CustomerName
StoreID
Purchase
I have dragged the StoreID to the "Row Lables", the CustomerName to
"Row Lables", the CustomerName to "Values", and Purchase to "Values".
As a result, my Pivot Table displays lines of purchases grouoped into
Stores (StoreID).
I would like to have an extra column in the Pivot Table which shows
how many lines are grouped in each StoreID group.
Can anybody help me with that?

Thanks,
David
Click to expand...

Hi David,

A stupid trick would be to add another column (name it Count) with the
value 1 in each cell. After, go to the PivotTables's Desing tab and
activate de Subtotals.

Pat
(e-mail address removed)
 
Back
Top