Calculation in Pivot Table

[AndrewKent]

Hi there,

I want to add a calculation to my pivot table.

Step 1: I want to multiply one field (which is a count) by the value in a Cell.

Is this possible?

Andy

 

[RoryA]

No, not within the table.

 

[texasaswang]

This can be accomplished by adding a column next to the pivot table which you can run a loop to do the calculations.

Do you need help with code for that?

 

[AndrewKent]

Thanks guys,

I managed to get round it

Andy