Averge per header instead of line level

[Anonymous]

dear all,

I have the following table:

Order	Orderline	Q
A	1	1000
A	2	500
A	3	10000
B	1	5000
B	2	2500
C	1	400
C	2	200
C	3	600
C	4	600
	average =	2311,1

The average of the lines is 2311, but i want an order average, which would look like this, with the following outcome:

Order	Orderline	Q	Order Q
A	1	1000	16500
A	2	500
A	3	10000
B	1	5000	7500
B	2	2500
C	1	400	1800
C	2	200
C	3	600
C	4	600
	average =	2311,1	8600

So where all the Q's are summed together, and then taken the average, so you know the average Q per order.

[amitchandak · Accepted solution]

@Anonymous ,

Try like

AverageX(Summarize(Table,Table[Order], "_1",sum(Table[Q])),[_1])