Last record for dimension with multiple equals values

v_ganchev — Thu, 18 Oct 2018 08:25:54 GMT

Table No.	Document Type	Article	Needed Quantity	Variant Code	Version No.
36	1	Article1	500	VariantCode1	0
36	1	Article1	0	VariantCode1	0
5107	4	Article1	1000	VariantCode1	2
5107	4	Article1	1000	VariantCode1	2

Hello.
This is example of my table in database.
How it's possible to get the last record for dimension Article column?

The result must be:

Article	Need Quantity	VariantCode
Article1	1000	VariantCode1

My idea was to use:
set NeedQty = FirstSortedValue('Need Quantity' - 'Version No_');

But when there is the equal Version No. it's showing null.

Thanks!

Re: Last record for dimension with multiple equals values

Gysbert_Wassenaar — Sun, 18 Nov 2018 08:59:32 GMT

Try =FirstSortedValue( aggr(max([Needed Quantity]),Article,[Version No.]), -aggr([Version No.],[Version No.],Article))

See attached qvw.