I am trying to create a pivot table. I have the following fields: cust#,
item#, and quantities for different months.

I want the pivot table to look like this:

data
cust item jan feb march
123 1 1 2 3
123 2 4 5 6
124 1 1 1 1


etc


But I am getting

cust item Data
123 1 sum of January 1
sum of February 2
sum of March 3
123 2 sum of Jan etc


How do I do this?

Thanks!