add a column (sort column) in vba pivot table

[nigelog]

I am very unversed in the magic of pivot tables ( never got one to work how I wanted it to), but with assistance from here have a pivot table output that saves much time.

A change in reporting format has led to a requirement to catagorise the pivot table data by county. At present it takes and sorts by a column "Waste Facility" and sums totals of actual weights.

I need to utilise a column in the data range "County" and add that to the pivot output so that the data is then sorted by county.

Code for pivot table as is

Please Login or Register  to view this content.

Any pointers appreciated

[rorya]

You'll need to add it as a row field. If it's the primary sort field, it needs to be the first row field.

[nigelog]

Hi Rory, these changes have given me a total of the number of waste facilities rather than the data in the column. I have moved the "County" column to "n" so the data is now contiguous

Please Login or Register  to view this content.

edit: by clicking on the table and clicking the checkbox for Waste Facility the data appeared how I need it. How can that be coded to do same??

[rorya]

Why did you make Waste facility a data field?

[nigelog]

I see that I don't need to add it as a data field because the data is in the pivot table, I just need to click on the checkbox for it to appear.

[rorya]

You should have left it as a rowfield as you had it originally.

[nigelog]

Thanks Rory, got there

Please Login or Register  to view this content.