Can you use two running total data items to calc a third data item

H

HDL

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?
 
M

Martin Fishlock

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.
 
Top