Hi!

I have two questions regarding pivot tables:

#1 - when inserting a custom formula in a pivot table, eg. divide field A with field B, what the pivot table does is to sum all records of A and divide it with the sum of all records of B. I'm assuming this is correct.

The question is: what if I want to divide the first record of A with the first of B, the second record of A with the second record of B, all the way to the nth record and then FINALLY, sum up the result?

I hope I was clear.

#2 - is it possible to multiply a pivot table total with another number? I tried to create a new formula but Excel tells me it isn't possible. Can I bypass this problem?

Thank you in advance!