How to sum an average in a pivot table

[#1]

How can you sum an average in a pivot table

I have a colom named FTE

1

1

1

1

1

this values come with the formule avg (FTE)

Only the  subtotal is now 1 but i want to see 5. A sum of (FTE) doesnt work i must work with the average.

Thank You

[giakoum]

Can you use a straight table instead of a pivot? There you can use sum of rows for the avg expression.

[Anonymous · Accepted solution]

Not quite clear because you didn't specify the dimensions.  But in general it may look like this:

sum(aggr(avg (FTE),dimensionfield))

Regards,

Michael

Edit: If there are multiple dimensions there, use all, comma-separated, instead of the dimensionfield above.

[Anonymous]

The Pivot Table does not cater for the average function on the Rows (this is coming in QV 11).

If you even try to 'fool' the chart by first making it a normal chart table with the average of the rows option enabled and then changing that chart to a pivot table, the totals will always be a straight total. As per other posts, your best bet is to use a normal chart table format.