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.

Hi,

Calculated fields and items do not allow references to ranges, names or
arrays.

Is A1:A2000 part of the source data for the pivot table, in other words, is
it a field of the pivot table?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Skywalker" wrote:

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.