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

# 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!

Si

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

I am guessing you have a simple count statement as the expression. if yes, leave that expression there count(cases) * 10

Then change the expression type to money.

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

Thanks, can I get the count to show alongside the £value?

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

Yes, just add another expression that has just the formula for count.

First Expression=Count(cases)*10

Second Expression=Count(Cases)

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

Thank You, sorted!