Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Give me the suggestion for the below screen shot. Attached the example file.
regards,
settu
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
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
Hi
This expression will do it:
=Sum(Aggr(Avg(Sales), Country))
HTH
Jonathan
Sorry, correction to the above:
If(Dimensionality() = 0, Sum(Aggr(Avg(Sales), Country)), Avg(Sales))
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.
pls see this attachment
Dharma
Did you see my correction?
If(Dimensionality() = 0, Sum(Aggr(Avg(Sales), Country)), Avg(Sales))
Hi Dharmarasu,
i need the result like the below screen shot
hi jonathan,
thank you for your expression. It showing the value. but day value shows 0. see the below screen shot.