4 Replies Latest reply: Aug 31, 2011 7:29 AM by Simon Gallantree RSS

    I know this is going to be an easy one, but.....

      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.