Pivot Table has count of data, not values

[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

 

[Ken Wright]

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