PDA

View Full Version : vba column to pivot table converted field



icemail
08-12-2016, 06:20 AM
hi

my question about add pivot calculation field. İ need to add some calculation field in pivot table with vba. min,max,average,x%,y%,z% columns can be converted calculated field ?

thx

16864

icemail
08-22-2016, 07:14 AM
How to convert this columns to pivot table calculation field with vba ?

thx



sample col1
sample col 2

sample col3
sample col4

sample col5
sample col 6


=MIN(C2:E2)

=MAX(C2:E2)

=AVERAGE(C2:E2)

=C2/B2

=D2/B2

=E2/B2



=MIN(C3:E3)

=MAX(C3:E3)

=AVERAGE(C3:E3)

=C3/B3

=D3/B3

=E3/B3



=MIN(C4:E4)

=MAX(C4:E4)

=AVERAGE(C4:E4)

=C4/B4

=D4/B4

=E4/B4



=MIN(C5:E5)

=MAX(C5:E5)

=AVERAGE(C5:E5)

=C5/B5

=D5/B5

=E5/B5