Pivot Table has count of data, not values

  • Thread starter Thread starter James & Melanie McIntosh
  • Start date Start date
J

James & Melanie McIntosh

I'm having trouble creating Pivot Tables. My application may be a little
unusual because my data does not comprise a complete array. ie for some
possible values of x and y there is no z. I am expecting a table of z
values with blanks.

Rather than having values of data in the main area of the table, I just get
a 1

eg
I get
1 2 3 4 5
------------------
1 | 1 1
2 | 1 1
3 | 1
4 | 1

I want
1 2 3 4 5
------------------
1 | 3 5
2 | 8 9
3 | 4
4 | 7

In the examples above, 3, 5, 8, 9, 4, 7 are data values, I just get 1's
indicating that these data values exist.

How do I get the values?

Thanks

James McIntosh
Melbourne
Australia
 
Click on one of those 1s, then right click and select 'Field settings'. Then in the 'Summarise
by' box, choose 'Sum' instead of 'Count'.
 
Back
Top