![]() |
PivotTable - Calculated Field
Thank you in advance for you effort
Current Pivot Set-up week 1 2 3 TOTAL SUBTOTAL % X Y X Y X Y Total X Total Y X Y A) 3 10 5 12 11 25 19 47 * B) 1 9 2 6 8 15 11 30 C) 5 11 5 11 5 11 15 33 SUBTOTAL: 45 110 D) 6 15 8 17 15 30 29 62 # TOTAL: 74 172 *I would like this percentage to have the following formula: =19/45 # This percentage should have the following formula: =29/74 How can I get this to work? Matt |
All times are GMT +1. The time now is 05:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com