ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot table formula with "show data as" value (https://www.excelbanter.com/excel-discussion-misc-queries/218323-pivot-table-formula-show-data-value.html)

Zsuzsi

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

Herbert Seidenberg

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