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 settu,

Pls see the above attached Application..it shows as it is what you required..

Dharma..

[dharmarasu]

otherwise u can use this expression in

average

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

[settu_periasamy]

Hi Dharmarasu,

Thank you. i checked it.  average is not correct. see the red border in the above screen shot.

Instead of 6131, it should be 1226.

Settu

[settu_periasamy]

Hi Jonathan & Dharmarasu,

i got the result using the below expresson, and attached the final layout.

    if(dimensionality()=0 and RowNo()=0 and ColumnNo()=0,

            Sum(Aggr(Avg(Sales), Country,day1))/Count(DISTINCT day1),

          if(Dimensionality()=0,

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