Total on Averaged value

[#1]

Hi

I have data on this format

Year	Quarter	Month	Amount
2013	Q1	1	100
2013	Q1	2	120
2013	Q2	4	90
2013	Q2	5	140
2013	Q3	7	110
2013	Q3	8	100
2013	Q4	11	80
2013	Q4	12	90

I wanted tocreate result as

Year	Quarter	Quarter Average	Year Total
2013	Q1	110	415
2013	Q2	115	415
2013	Q3	105	415
2013	Q4	85	415

Thanks,

[whiteline]

Create Chart. Use Year and Quarter as dimensions.

Quarter Average =Avg(Amount)

Year Total =Sum(total Amount)

[#3]

Hi Whiteline,

Thank you for your reply.

I tried to code that way. The result is attached.

Year	Quarter	avg(Amount)	sum(TOTAL Amount)
		103.75	830
2013	Q1	110	830
2013	Q2	115	830
2013	Q3	105	830
2013	Q4	85	830

Please advice. The toal column should be 415 rather 830.

[Gysbert_Wassenaar · Accepted solution]

Try: sum(total aggr(avg(Amount),Quarter))