VBA Pivot Tables? One field as legend and value?

[Oracus]

Just wondering if someone could link to an example of VBA code where one column from the original data table is used as a legend, and again as a count in the pivot, generated by VBA.

I've tried recording it, and coding it, but keep getting stuck with the same problem - it will add the column as a legend in the pivot table, but once added as a count in the value field, it removes it as the legend.

Odd that you can do it manually, but struggle to do it via VBA - or I'm missing something quite simple (most probably the latter).
Would be appreciative of any pointers you might have.

Ta,

Oracus

[Izandol]

You must add data field first:

Please Login or Register  to view this content.

[Oracus]

That's done it - Thank you!!