Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Yes, just add another expression that has just the formula for count.
First Expression=Count(cases)*10
Second Expression=Count(Cases)
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.
Thanks, can I get the count to show alongside the £value?
Yes, just add another expression that has just the formula for count.
First Expression=Count(cases)*10
Second Expression=Count(Cases)
Thank You, sorted!