I want to divide a running total expense amount by a running total unit
amount on a running total basis in a Pivot Table. I have successfully
created the expense and units running totals. How do I bring them together
in a Pivot table?

Hi HDL

Try using a calculated field in your pivot table but I've a feeling that it
will do the individual and then sum them which will not the same as
total/total.

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"HDL" wrote:

I want to divide a running total expense amount by a running total unit
amount on a running total basis in a Pivot Table. I have successfully
created the expense and units running totals. How do I bring them together
in a Pivot table?