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

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

--
steven100
-----------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...fo&userid=3075
View this thread: http://www.excelforum.com/showthread.php?threadid=52726