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

[#1]

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

[#2]

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.

[#3]

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

[#4 · Accepted solution]

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

First Expression=Count(cases)*10

Second Expression=Count(Cases)

[#5]

Thank You, sorted!