Hello - I am having trouble coming up with a solution for this need. If you look at the chart below, you will see that "Item 1" has an "Ordered QTY" of 16. We actually have 200 ("Item QTY") of that item. However, showing all 200 in the pivot is not necessary, I only need to show enough quantity to fill the order.
What I'm looking to do is filter rows once the running total of the column "Item QTY" exceeds or meets "Ordered QTY". For the "Item 1" example, I need to show rows 3, 4, and 5. Rows 6,7,8 are not needed since the we have already displayed enough quantity to fill the order.
Any suggestions? I'm guessing it's easier than I'm making it. I'm still trying to get the hang of QlikView.
Thanks in advance,