EXCEL 2007

"Any suggestion in how can I get how many invoices were issued in a
particular month?"


Take the following actions to achieve the above:-

1. Drag your date field (column) into the Values area of the PivotTable
Field List (lower right hand corner).

2. Doing the above should then give you, in your Pivot Table, a Count of
Date column and it is here that you will see the number of invoices issued in
each month.

If my comments have helped please hit Yes.

Thanks.





"Rubem" wrote:

Hi,

I have a table if several columns. One of them is Invoice Date. I am using
Pivot Table to compile the data. I am trying to find out how many invoices
were issued in a particular month. First I convert the mm/dd/yy into mm/yy,
but the Pivot Table gave me the result as mm/dd/yy. Then I copied the mm/yy
and past special - value. Still I got mm/dd/yy on my Pivot Table.

Any suggestion in how can I get how many invoices were issued in a
particular month?

Thank you.

Rubem