S
Skywalker
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.
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.