Total sum of average values

[#1]

Hi,

I have a pivot table with only one dimension and only one expression.

The expression consist of an average, =AVG(field)

When I check the checkbox 'Show partial sums' in the tag 'presentation' it shows a total which is an average but I need a sum of the averages in the table.

How could I get this total as a sum?

Thanks.

[#2 · Accepted solution]

Hi ,

Try using this expression  sum(Aggr(  Avg(field),dimension field))

Regards

[jagan]

HI,

Try like this

=Sum(Aggr(Avg(Field), DimensionName))

Regards,

Jagan.

[tamilarasu]

Hi Luis,

Try,

If(Dimensionality()=0,Sum(Field),Avg(Field))

[MayilVahanan]

Hi

Try like this

=Sum(Aggr(Avg(FieldName), DimensionName))

[luciancotea]

Well, it's unusual to display the sum of averages... but here you go:

Since you can't change the total expression to "Sum of rows" like in a straight table, you could check the level of aggregation using DIMENSIONALITY(). See the help on using it.

Or, you could switch to straight table and change the expression total calculation mode.