How to write expression for monthly Rate X sales by month ?

[paulyeo11]

Hi All

I have a sales table below :-

Rate for 20 Jan = 20 

Rate for 20 Feb = 25

Sales for 20 Jan = 270,569

Sales for 20 Feb = 446,865

How to write expression = 20 X 270,569 + 25 X 446,865 

Paul

[Vegar · Accepted solution]

Try something like this:

=Sum(Aggr(Only(Rate)*Sum(sales), YearMonth))

[paulyeo11]

Hi Sir

Thank you very much

Paul