Use of Functions in a Pivot Table ?

  • Thread starter Thread starter Alfredo
  • Start date Start date
A

Alfredo

Is there a way I can add a Calculated Field within a Pivot
Table using the "Average" or "Count" function that's used
in regular Excel spreadsheets ?

Thanks !!!
 
Alfredo,

maybe I misunderstand you but you can use that, right click in the table and select field settings, there you can select from sum,
count, average, max, min etc.
 
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.

-----Original Message-----
Alfredo,

maybe I misunderstand you but you can use that, right
Click to expand...
click in the table and select field settings, there you
can select from sum,
count, average, max, min etc.
--
Regards,

Peo Sjoblom


"Alfredo" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
 
Back
Top