hi
a,b,c,d,e pivot table colums.
f,g,h,ı,j,k my formula columns.(sample columns)
can i add my formula columns with vba "calculation field add"?
i wish to turn my formula colums to pivot table calculation field(sample colums => calculation field with vba)
my sample data is down
thx
<tbody>
</tbody>
a,b,c,d,e pivot table colums.
f,g,h,ı,j,k my formula columns.(sample columns)
can i add my formula columns with vba "calculation field add"?
i wish to turn my formula colums to pivot table calculation field(sample colums => calculation field with vba)
my sample data is down
thx
| Sub-Category 2 | base price | Average x custumer price | Average y custumer price | Average z customer price | sample col1 | sample col 2 | sample col3 | sample col4 | sample col5 | sample col 6 |
| Appliances 1 | 21,78 | 29 | 22 | 30 | MIN(C2:E2) | MAX(C2:E2) | AVERAGE(C2:E2) | C2/B2 | D2/B2 | E2/B2 |
| Appliances 2 | 21,78 | 29 | 29 | 25 | MIN(C3:E3) | MAX(C3:E3) | AVERAGE(C3:E3) | C3/B3 | D3/B3 | E3/B3 |
| Binders and Binder Accessories 1 | 2,08 | 6 | 4 | 7 | MIN(C4:E4) | MAX(C4:E4) | AVERAGE(C4:E4) | C4/B4 | D4/B4 | E4/B4 |
| Binders and Binder Accessories 2 | 3,52 | 3 | 4 | 5 | MIN(C5:E5) | MAX(C5:E5) | AVERAGE(C5:E5) | C5/B5 | D5/B5 | E5/B5 |
| Binders and Binder Accessories 3 | 5,98 | 7 | 6 | 8 | MIN(C6:E6) | MAX(C6:E6) | AVERAGE(C6:E6) | C6/B6 | D6/B6 | E6/B6 |
| Bookcases 1 | 81,94 | 65 | 95 | 80 | MIN(C7:E7) | MAX(C7:E7) | AVERAGE(C7:E7) | C7/B7 | D7/B7 | E7/B7 |
| Bookcases 2 | 100,98 | 88 | 73 | 70 | MIN(C8:E8) | MAX(C8:E8) | AVERAGE(C8:E8) | C8/B8 | D8/B8 | E8/B8 |
| Chairs & Chairmats 1 | 120,98 | 125 | 147 | 137 | MIN(C9:E9) | MAX(C9:E9) | AVERAGE(C9:E9) | C9/B9 | D9/B9 | E9/B9 |
| Chairs & Chairmats 2 | 122,99 | 163 | 210 | 196 | MIN(C10:E10) | MAX(C10:E10) | AVERAGE(C10:E10) | C10/B10 | D10/B10 | E10/B10 |
| Computer Peripherals 1 | 30,98 | 29 | 28 | 30 | MIN(C11:E11) | MAX(C11:E11) | AVERAGE(C11:E11) | C11/B11 | D11/B11 | E11/B11 |
| Computer Peripherals 2 | 39,48 | 52 | 50 | 40 | MIN(C12:E12) | MAX(C12:E12) | AVERAGE(C12:E12) | C12/B12 | D12/B12 | E12/B12 |
| Computer Peripherals 3 | 49,99 | 38 | 39 | 34 | MIN(C13:E13) | MAX(C13:E13) | AVERAGE(C13:E13) | C13/B13 | D13/B13 | E13/B13 |
| Envelopes 1 | 4,48 | 6 | 6 | 4 | MIN(C14:E14) | MAX(C14:E14) | AVERAGE(C14:E14) | C14/B14 | D14/B14 | E14/B14 |
| Envelopes 2 | 5,58 | 7 | 2 | 8 | MIN(C15:E15) | MAX(C15:E15) | AVERAGE(C15:E15) | C15/B15 | D15/B15 | E15/B15 |
| Envelopes 3 | 5,68 | 5 | 7 | 4 | MIN(C16:E16) | MAX(C16:E16) | AVERAGE(C16:E16) | C16/B16 | D16/B16 | E16/B16 |
| Labels 1 | 2,88 | 8 | 2 | 2 | MIN(C17:E17) | MAX(C17:E17) | AVERAGE(C17:E17) | C17/B17 | D17/B17 | E17/B17 |
| Labels 2 | 3,69 | 9 | 8 | 6 | MIN(C18:E18) | MAX(C18:E18) | AVERAGE(C18:E18) | C18/B18 | D18/B18 | E18/B18 |
| Office Furnishings 1 | 5,8646 | 7 | 7 | 8 | MIN(C19:E19) | MAX(C19:E19) | AVERAGE(C19:E19) | C19/B19 | D19/B19 | E19/B19 |
| Office Furnishings 2 | 26,2314 | 22 | 25 | 27 | MIN(C20:E20) | MAX(C20:E20) | AVERAGE(C20:E20) | C20/B20 | D20/B20 | E20/B20 |
| Office Furnishings 3 | 34,4324 | 45 | 57 | 34 | MIN(C21:E21) | MAX(C21:E21) | AVERAGE(C21:E21) | C21/B21 | D21/B21 | E21/B21 |
| Paper 1 | 5,0504 | 9 | 8 | 4 | MIN(C22:E22) | MAX(C22:E22) | AVERAGE(C22:E22) | C22/B22 | D22/B22 | E22/B22 |
| Paper 2 | 5,8764 | 2 | 2 | 2 | MIN(C23:E23) | MAX(C23:E23) | AVERAGE(C23:E23) | C23/B23 | D23/B23 | E23/B23 |
| Pens & Art Supplies 1 | 2,88 | 10 | 7 | 3 | MIN(C24:E24) | MAX(C24:E24) | AVERAGE(C24:E24) | C24/B24 | D24/B24 | E24/B24 |
| Pens & Art Supplies 2 | 4,84 | 5 | 4 | 2 | MIN(C25:E25) | MAX(C25:E25) | AVERAGE(C25:E25) | C25/B25 | D25/B25 | E25/B25 |
| Rubber Bands 1 | 2,18 | 9 | 2 | 8 | MIN(C26:E26) | MAX(C26:E26) | AVERAGE(C26:E26) | C26/B26 | D26/B26 | E26/B26 |
| Rubber Bands 2 | 2,62 | 4 | 5 | 4 | MIN(C27:E27) | MAX(C27:E27) | AVERAGE(C27:E27) | C27/B27 | D27/B27 | E27/B27 |
| Scissors, Rulers and Trimmers 1 | 3,68 | 8 | 10 | 8 | MIN(C28:E28) | MAX(C28:E28) | AVERAGE(C28:E28) | C28/B28 | D28/B28 | E28/B28 |
| Scissors, Rulers and Trimmers 2 | 12,98 | 19 | 15 | 15 | MIN(C29:E29) | MAX(C29:E29) | AVERAGE(C29:E29) | C29/B29 | D29/B29 | E29/B29 |
| Storage & Organization 1 | 34,76 | 49 | 48 | 34 | MIN(C30:E30) | MAX(C30:E30) | AVERAGE(C30:E30) | C30/B30 | D30/B30 | E30/B30 |
| Storage & Organization 2 | 59,76 | 55 | 53 | 52 | MIN(C31:E31) | MAX(C31:E31) | AVERAGE(C31:E31) | C31/B31 | D31/B31 | E31/B31 |
| Tables 1 | 100,8 | 62 | 75 | 69 | MIN(C32:E32) | MAX(C32:E32) | AVERAGE(C32:E32) | C32/B32 | D32/B32 | E32/B32 |
| Tables 2 | 218,75 | 121 | 124 | 140 | MIN(C33:E33) | MAX(C33:E33) | AVERAGE(C33:E33) | C33/B33 | D33/B33 | E33/B33 |
| Telephones and Communication 1 | 20,99 | 21 | 30 | 29 | MIN(C34:E34) | MAX(C34:E34) | AVERAGE(C34:E34) | C34/B34 | D34/B34 | E34/B34 |
| Telephones and Communication 2 | 65,99 | 90 | 70 | 91 | MIN(C35:E35) | MAX(C35:E35) | AVERAGE(C35:E35) | C35/B35 | D35/B35 | E35/B35 |
| Telephones and Communication 3 | 65,99 | 77 | 74 | 74 | MIN(C36:E36) | MAX(C36:E36) | AVERAGE(C36:E36) | C36/B36 | D36/B36 | E36/B36 |
<tbody>
</tbody>
