pivot table based on multiple ptables?
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 |
pivot table based on multiple ptables?
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 |
All times are GMT +1. The time now is 02:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com