Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this:
=Sum(Aggr(Avg(Value), Project, CodeNr))