Display Average Column

[#1]

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?

[preminqlik]

hi there,

hope this helps you

[tresB]

Use expression like: If(dimensionality()=1, Avg(YourMeasurefield), Sum( YourMeasurefield)

Then enable partial sum in the presentation tab for second dimension. PFA

[#4]

Results come up wrong...

Why?