Macro for creating Calculated Fields?

[gammaves]

I'm looking for a macro that I can use to create two calculated fields on a pivot table - I have to create these upwards of 10 times every day!

The first one would be called "Conversion Ratio":
='Hits Unique' /Signups

And the second one would be
"Rev per Sale"
='Initial Revenues / AUTH'/Signups

Also, is it possible for the macro to format them?
The first would be "number" with a comma spacer and 0 decimals. The second is simply "Currency".


Thanks for your help!

 

[gammaves]

Anyone? I'm sure someone out here has to know!