Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all
I have an inventory table with purchase and sales positions.
ID | Type | Date | Quantity |
---|---|---|---|
A | Purchase | 31.01.2012 | 100,00 |
A | Sales | 25.08.2012 | -50,00 |
B | Purchase | 28.02.2012 | 222,00 |
B | Sales | 01.05.2012 | -22,00 |
C | Purchase | 31.01.2012 | 50,00 |
C | Purchase | 01.08.2012 | 75,00 |
C | Sales | 01.03.2012 | -25,00 |
C | Sales | 01.10.2012 | -10,00 |
D | Purchase | 31.12.2012 | 60,00 |
ID | Type | Date | Quantity |
---|---|---|---|
B | Purchase | 28.02.2012 | 222,00 |
D | Purchase | 31.12.2012 | 60,00 |
Can somebody help me out here ?
I do attach my sample qvw.
Thanks a lot.
Cheers
Joerg
Basing on Date 31.12.2012, I need to see all ID which had no Sales since 01.07.2012
The result should look like this
See attached qvw
Great Gysbert !
That's what I was looking for.
Thx a lot.
Joerg