Changing Pivot Table Field Values

Hi

The code below produced a nice Pivot Table for me but all the data in the data field "Number of Heats won against" comes out as a "Value" meaning any number is shown as "1" rather than the actual number. How do I get the Field Value for "Number of Heats won against" to be "Max" please??

Please Login or Register  to view this content.

Cheers

Frankie

Frankie, for MAX, check out the .Function property of the PivotField, e.g.:

Please Login or Register  to view this content.

However, it sounds as though your source values may not be stored as numbers, or at least that field contains some non-numeric values
(if all values were numeric the datafield would default to SUM as opposed to COUNT)

Hi XLent

Thanks for the response. However, when I put your code into my code it throws up "Run-time error 438. Object doesn't support this property or method" with de-bug highlighting .Orientation = xlDataField.

The "Number of Heats won against" column the data is being taken from is all numbers from 0 to 4 (at the moment although it could be any number) and are coming out in the PT as "COUNT".

The PT its self shows all the Team names in xlRowField but does have a (Blank) line at the end of the list of names with nothing in that row but this doesn't show in the PT if I change the Range in

Please Login or Register  to view this content.

from ("Y:AE") to ("Y1:AE50"). But the run-time error persists. (The Range really needs to be variable as the number of teams in the list changes)

Any ideas why please?

Frankie

HA!! Cracked it!!

Please Login or Register  to view this content.

That works. Thanks for the input XLent. Put me on the right track!

Frankie