Sum a value and by grouping

Ask for Help
1

Hi,
To make a certain quantity of the TRI00155 knitwear, I have linked the necessary yarn orders (FIL00227 and FIL00129). I would like to determine the cumulative quantity per type of yarn. Does anyone have any tips on how to do this?

c1
c1484×961 47.7 KB

c2
c2490×965 49.2 KB

c3
c3489×964 48.4 KB

2

So you want to show the cumulative sum of FIL00227 and FIL00129, providing there can be multiple instances of each in the query?

3

Yes. To solve this problem, I decided to create a additionnal table that directly links the yarn type (FIL00227 and FIL00129) and the knitwear (TRI00155). I’ll use this table to evaluate cumulative quantity for each yarn.
image
Thanks.

1 Like