K
kenicholls
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
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