Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts !!
I 'd like to have Quantity and (Quantity * Sales unit price ) results per year. I tried to apply partial sum but as you can see in the attached picture, the total did not work on the line which have 540 , 540, 180. numbers .
It seems that I have to use aggr() , but first I 'd like to have your point of view.
Thousands thanks,
Southinho
Use RangeSum
Change Sum by RangeSum