Hi.

I am trying to do something with a pivot table but haven't been able to figure out how....

I have a large list of raw data with defect places (e.g. engine, brakes) defect types (e.g. noisy) and week off occurance.


I have a pivot table to count all the items and give me a table with defect places, then defect type, and a column for each week, with how many occurances there are that week.


What I would like to do, is rather than having a straight count of the number of each item in each week, have this count divided by a fixed number (different number for each week).

I have tried playing around with calculated fields but haven't been able to do it!

Can anyone help?


Thanks