I have a pivot table which summarizes loan count and total conditions by an employee. The pivot table looks like this
Product Family 1
Row Labels Count of loans Count of conditions
Employee 1 1 33
Employee 2 2 35
I want to insert a calculated field in the pivot table that would do "count of conditions/count of loans".
Looks like I cannot use aggregates in calculated fields.
I wont be able to do the calculation in the originial datapull since i want to calculate conditionsperloan for each employee by product family.
I would appreciate any suggestions on this.
Thank you,
Regards
Laxman
Bookmarks