Excel 2007 PivotTables

[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

 

[PatriceRoy]

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

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)