![]() |
Pivot table formula with "show data as" value
Hi,
I have two columns in a pivot table with data in time order and they are showed as 'Running total in' - base field 'Month'. I would like to have a result in the pivot table to have the ratio of one to the other in each month with the 'Running total in' values. Is it possible ? Thanks, Zsuzsi |
Pivot table formula with "show data as" value
Excel 2007
Best done with a dynamic auxiliary Table: http://www.mediafire.com/file/mm2nimtycio/01_29_09.xlsm |
All times are GMT +1. The time now is 03:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com