Grouping per dimension before calculation

[MiaData]

Hi community,

I am new to Looker and still getting the hang of the Looker way, and I am running into problems with how to group the data, I am working with.

I have a lowest-level table where each row represents a product in an order. We only want to look at some of them, so a custom dimension is made where the number for these lines is displayed.

Now I need to group all these lines per order and then multiply that number by a constant and view them per day.

So far I have only been able to either sum all the lines before multiplying or multiplying the initial individual lines, both of which does not give the result we need.

I hope you can help! 🙂