Can you use two running total data items to calc a third data item
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? |
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? |
All times are GMT +1. The time now is 09:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com