Combined chart and data aggregation

[GiuQlik7]

Hi, I'm continuing to play with this fascinating tool and I thought of a chart to be obtained 
by aggregating data. In practice I have available the distribution of the values ​​of a dimension and I would like 
to obtain in addition to this distribution also the average trend or the sum of all the detail 
values.
I show an example obtained by simplifying my idea with excel.


Obviously I would like to get a single chart combinated.

can you advise me on how to aggregate data? 

I have to do this with the data load editor or I can get the graph directly using the functions 

in the sheet analysis? 

Thank you! 🙂