Pivot table, calculating a new field derived from other field, e.g

[Guest]

I want to show a field called "Collection Rate" that is based on two other
fields, namely, "Charges" and "Payments". It is not possible to do this in
the database because you can't add up or average percentages--the result will
not be properly weighted for different levels of summarization. Therefore,
it needs to be derived from the values that are shown in the pivot table
itself. How can I do this?

 

[Guest]

You can create a formula field in the pivot table.

Use the pivot table toolbar and select formulas from there. You'll need to
construct the formula in the silly little dialog box that you get, but it
should do exactly what you want.

James.