pivot table based on multiple ptables?

[kenicholls@gmail.com]

Hi there,

I'm trying to run some reports based on the following data fields:


User | Usage Description | Usage amount
A Fsearch 3
A browse 4
A Bsearch 1
B Fsearch 4
C browse 10
C Bsearh 4


The User to Usage Description is a one to many relationship as there
are multiple types of usage. And, to make it a bit more complicated,
the data is being supplied monthly, so I have monthly sheets which I'd
like to see the usage totals of per person over a series of months.


The monthly data is easily put into a pivot table which calculates the
total of Usage amount per User. I've tried to create a pivot table
based on monthly data, but instead of usage amount TOTALS, i get the
total of fields Usage appeared per User. Is there a way to create
pivot table based on the calculated totals and not the amount of times
the field appears?


Thanks in advance for your help!


Kyle

[steven1001]

right-click on a number in the pivot table and check that it is set to "sum" not "count"