Prev: running time
Next: filtering: sometimes data below blank lines is &isnt available?
From: Pierre on 19 Feb 2010 15:34
Using EW2007.

Trying to insert a calculated field into a pivot table. It's not
displaying any results besides zero's on the calculated field.
I think what may be contributing to the lack of results, is that one
of the source fields used in the custom calculation is already used
twice in the pivot table. (once in the row labels area on the
left(displayed as its field value), and another time in the values and
is displayed as "Count".)
Any ideas of how I might get this calculated field to. . . calculate?
TIA. . .
Pierre
From: Debra Dalgleish on 19 Feb 2010 20:24
Does the field contain text? If so, its sum is zero, so that's what's
used in the calculated field.

Pierre wrote:
> Using EW2007.
>
> Trying to insert a calculated field into a pivot table. It's not
> displaying any results besides zero's on the calculated field.
> I think what may be contributing to the lack of results, is that one
> of the source fields used in the custom calculation is already used
> twice in the pivot table. (once in the row labels area on the
> left(displayed as its field value), and another time in the values and
> is displayed as "Count".)
> Any ideas of how I might get this calculated field to. . . calculate?
> TIA. . .
> Pierre


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

 | 
Pages: 1
Prev: running time
Next: filtering: sometimes data below blank lines is &isnt available?