ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   PivotTable - Calculated Field (https://www.excelbanter.com/excel-worksheet-functions/68806-pivottable-calculated-field.html)

Matt M HMS

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