D
dvcas
What is the easiest way to isolate rows in a single table, which are an
grouped by an item then by a sub item, but only when the sub item sum is less
then 0.
123-item
1234-sub-item 10
456-item
4567-sub-item -10
4567-sub-item 10
567-item
345-sub-item -10
345-sub-item -10
so I would only want 567-item with 345-sub-item to be displayed.
Thanks in advance.
grouped by an item then by a sub item, but only when the sub item sum is less
then 0.
123-item
1234-sub-item 10
456-item
4567-sub-item -10
4567-sub-item 10
567-item
345-sub-item -10
345-sub-item -10
so I would only want 567-item with 345-sub-item to be displayed.
Thanks in advance.