First and second highest by product in one row

[pavandbs]

Hello Experts,

Please help to write a set expression for the below output

For each product show in one row

1.Latest Date

2. Latest Purchase Unit

3. Latest Invoice vendor

4. 2nd Latest Date

5. Purchase Unit for the 2nd latest date

6. Invoice Vendor for the 2nd latest date

In one the two lines highlighted in green should show as one row in output by product.

Please note some products may contain null date, invoice vendor also

[pavandbs]

Hi Sunny,

Glad that you messaged. I have tried hard to get the expected output literally spent 2 days. Got struck with 2nd highest values to pick. Greatly appreciate if you could help on this solution. I guess some null values causing the issue.

Thanks,

Pavan

[sunny_talwar · Accepted solution]

You mentioned that you wanted to get the same output as the image... what is the issue here? Nulls seems to be because of non-existance of 2nd latest date... do you know a case where you know there is a 2nd latest date, but you don't see it on the chart?

[pavandbs]

Sorry I didnt see the attached. Let me check and get back to you

Thanks,

Pavan Ch

[pavandbs]

awesome. Thanks a lot.