Hello everybody. I use Excel 2007 at work. I know everything I need to know
to do my work and more, but I having problems with something.

I have PivotTable, and I want to make "Calculated Field" with this formula:
"=COUNT(A1:A2000)". The formula on an excel spreadsheet works fine, but on a
PivoteTable shows 1 row. When I double-click on the information it shows me 4
rows, so Is not 1, is 4 the correct result.

Just FYI, column A are numbers, no blank, no text, no symbols, just numbers.

I know that I can count just by adding the column to the raw data field and
change the formula count, by I need to it with a Calculated Field.

Thank you very much to all.
--
Some day I''ll be the most powerful Jedi ever.