Can you use two running total data items to calc a third data item
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?
|