2007 Pivot table Calculated field misbehaving

P

Pierre

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
 
D

Debra Dalgleish

Does the field contain text? If so, its sum is zero, so that's what's
used in the calculated field.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Pivot Table Calculated Field 0
Calculated Item in Pivot table 1
Slicers and Calculated Items in Pivot Table 2
Pivot Table - Calculated Field 2
Pivot Table Field based on two data area fields 3
Excel 2003 Pivot Table Problem - Can No Longer Create Calculated Field 0
Using Mid Function with Pivot Table Calculated Item 0

Top