This content has been marked as final. Show 4 replies
Hi - I have created a pivot, which gives me a count of cases by agent.
How do I then calculate those cases by a £ value.
For example - J. Bloggs shows 5 cases in the pivot table. I want to multiply those cases by £10 each, so that the pivot would show the name (J. Bloggs), the case count (5) and the amount £50.
I'm pretty sure this won't be hard to do, but guess if you don't know how to do it, you don't know how to do it!
Thanks for your help.