Pivot table Sum of average

[settu_periasamy]

Hi All,

Give me the suggestion for the below screen shot. Attached the example file.

regards,

settu

[dharmarasu]

Hi,

in that above Screen shot showing correct..nothing wrong in it..

In that average showing Average(1267+1281+1277)=1275..ie (1267+1281+1277)/3=1275..Hope this helps..

Dharma

[settu_periasamy]

Hi Dharmarasu,

Already there is an average for country level. I need the sum of Country average in the dimension level. i.e

if (dimensionality()=0, sum(801 average, 802 average and 803 average). Hope i clear now..

Settu

[jonathandienst]

Hi

This expression will do it:

=Sum(Aggr(Avg(Sales), Country))

HTH

Jonathan

[jonathandienst]

Sorry, correction to the above:

If(Dimensionality() = 0, Sum(Aggr(Avg(Sales), Country)), Avg(Sales))

[settu_periasamy]

hi Jonathan,

If we give that expression, the sum value is changed. Already the sum value is correct. i need to change the dimension total only. see the arrow mark in that picture.

[dharmarasu]

pls see this attachment

Dharma

[jonathandienst]

Did you see my correction?

If(Dimensionality() = 0, Sum(Aggr(Avg(Sales), Country)), Avg(Sales))

[settu_periasamy]

Hi Dharmarasu,

i need the result like the below screen shot

[settu_periasamy]

hi jonathan,

thank you for your expression. It showing the value. but day value shows 0. see the below screen shot.