I have data on this format
I wanted tocreate result as
Create Chart. Use Year and Quarter as dimensions.
Quarter Average =Avg(Amount)
Year Total =Sum(total Amount)
Thank you for your reply.
I tried to code that way. The result is attached.
Please advice. The toal column should be 415 rather 830.
Try: sum(total aggr(avg(Amount),Quarter))
Retrieving data ...