Pivot Table events

[peacenik]

I have some code that I want to run after changing a PivotFields().currentpage but I can't find an event to trigger it. Is it possible to create a Class Module for PivotTable events? Are there any other suggestions?

What I want to do is to display a calculation of the second last column of the pivot, divided by the last column of the pivot.

I am using Excel 2000.

[geekgirlau]

Have you tried creating this as a calculated field?

[peacenik]

Do you mean within the Pivot Table? If so, I need to know more than I do now about Pivot Tables. I want to divide the last column (only) by the Total. Can I do that in a calculated field?

[peacenik]

I checked out Calculated fields and I don't think it will work, because I want to divide the total of a particular column (which is always the last column) by the grand total. From what I can see, Calculated fields doesn't do this.

[geekgirlau]

Can you post a sample workbook?

[XLGibbs]

Yes, you can show this without doing anything fancy.

Drag the column you want as the numerator into the pivot table data area.

Click the field settings options and choose advanced.

Choose to show the field as a % Of ___
and pick the option that suits your needs best (row,column or "previous" might work in your example)