Calculated Item / Field in a Pivot Table

Hi everyone

I don't seem to be able to acheive the calculation I need in a pivot table. I need the 'Liability' total divided by the 'Count of Branch' but I keep getting the 'Divided by Zero' error. I have tried changing numeric values to count also but that just calculates the total numeric value that sits behind. What am I doing wrong? Any tips will be greatly appreciated.

Values
Row Labels Count of Branch TOTAL LIMITS Sum of Field3
FIDELITY COMM 7,597 3,655,800,000 #DIV/0!
FIDELITY FIN 375 25,014,500 #DIV/0!
MLC 9,169 27,463,660,000 #DIV/0!
MLF 375 68,785,500 #DIV/0!
PI 5 7,500,000 #DIV/0!
Grand Total 17,521 31,220,760,000 #DIV/0!


Cheers

Derek

Hi Sixthsense

Thank you for your reply and apologies for my delayed response. I have attached a desensitised source version of what I am trying to achieve. Essentially I want to divide the 'Sum of Liability' with the 'Count of Type' in the pivot table but I am having no luck.

Thanks in advance for any help you can offer.

PS I hope teh attachment worked!

Cheers

Derek

Hi MarvinP

Thanks for your reply. The actual pivot data is much larger in the full version and the filters on the pivot will be frequently used so I really need, if possible, for the calculation to be within the pivot - if there is a way!!

Cheers

Derek

You are absolutley correct - if you are able to change from Sum to Count etc then the calculated item or field shoud follow however as you pointed out iy calculates from the record itself - frustrating! It seems I am unable to find a way around it.

Cheers

Derek

That works perfectly, thanks!! I was trying all these complex methods but it is often the simplest that works best...

Thank you very much Izandol, much appreciated.

Cheers

Derek