Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
I have this pivot presented:
Period James David Daniel
2012/1 100 150 200
2012/2 200 300 100
2012/3 300 500 400
I want to present an average column for each month (as last column)
I tried adding another expression it adds this column for each salesman.
how do i do it?
hi there,
hope this helps you
Use expression like: If(dimensionality()=1, Avg(YourMeasurefield), Sum( YourMeasurefield)
Then enable partial sum in the presentation tab for second dimension. PFA
Results come up wrong...
Why?