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.....

    Simon Gallantree

      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.

       

      Si