A
Alfredo
Thanks Peo, for your help....
I'll see if I can try to put in words my problem. This is
an example of what I'm looking for:
I have a column named "Last Day of Month" and that finds
the last day of the month for each Loan in a database.
I create a Pivot Table that brings the Sum of Loan
Balances, the Sum of Interest Balances, and the Average
for "Last day of the Month". The purpose is to find the
Yield Revenue, in a monthly basis, by Loan Type by using
the formula (Interest*(365/Average Number of days in
month)/Loan Balance).
The problem is that when I insert a "Calculated Field" to
determine the Yield Revenue, the formula will ADD
the "number of days in month" instead of using the Average
value originally calculated when the Pivot Table was first
created. I hope this helps to better unterstand the issue.
Here is where my question comes: Is there a way I can add
a CALCULATED FIELD in a Pivot Table already created using
the "Average" or "Count" function that's used
in regular Excel spreadsheets ?
I'll see if I can try to put in words my problem. This is
an example of what I'm looking for:
I have a column named "Last Day of Month" and that finds
the last day of the month for each Loan in a database.
I create a Pivot Table that brings the Sum of Loan
Balances, the Sum of Interest Balances, and the Average
for "Last day of the Month". The purpose is to find the
Yield Revenue, in a monthly basis, by Loan Type by using
the formula (Interest*(365/Average Number of days in
month)/Loan Balance).
The problem is that when I insert a "Calculated Field" to
determine the Yield Revenue, the formula will ADD
the "number of days in month" instead of using the Average
value originally calculated when the Pivot Table was first
created. I hope this helps to better unterstand the issue.
Here is where my question comes: Is there a way I can add
a CALCULATED FIELD in a Pivot Table already created using
the "Average" or "Count" function that's used
in regular Excel spreadsheets ?