Total instead of average in pivot table

[Anonymous]

Hi everyone,

I have a small table showing project, codenr and value.  From the data in this table, I have created a pivot table with project and codenr as dimensions and Avg(value) as measure.

I want to show the subtotals by codenr.  Instead of calculating a total, QV calculates an average.  How can I solve this ?

I have also attached the app.

Thanks in advance for your suggestions.

[sunny_talwar]

Try this:

=Sum(Aggr(Avg(Value), Project, CodeNr))