Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Widget SerNo | Ship Date | Counter |
---|---|---|
1 | 1/1/2011 | 1 |
1 | 4/4/2011 | 2 |
2 | 1/2/2011 | 1 |
3 | 3/5/2011 | 1 |
4 | 2/1/2011 | 1 |
4 | 4/1/2011 | 2 |
5 | 1/1/2011 | 1 |
5 | 2/1/2011 | 2 |
5 | 3/1/2011 | 3 |
6 | 3/5/2011 | 1 |
Widget SerNo | Ship Date | Counter |
---|---|---|
1 | 4/4/2011 | 2 |
2 | 1/2/2011 | 1 |
3 | 3/5/2011 | 1 |
4 | 4/1/2011 | 2 |
5 | 3/1/2011 | 3 |
6 | 3/5/2011 | 1 |
Thanks,
John
You can use firstsortedvalue with a reversed order.
Ship date expression would be, firstsortedvalue([Ship date],-[Ship date]) and counter firstsortedvalue(Counter,-[Ship date]).
You can use firstsortedvalue with a reversed order.
Ship date expression would be, firstsortedvalue([Ship date],-[Ship date]) and counter firstsortedvalue(Counter,-[Ship date]).
use this function
-firstsorted value function.
it gives you last value..
I had a feeling it would be FirstSortedValue-something-or-other. I see the '-' sign designates the last record rather than the first record...perfect.
Thanks Daniel
This seems to return a negative value of what I'm seeking, date or counter.