Set Analysis help

Joaquin_Lazaro — Thu, 17 Jan 2013 14:34:21 GMT

Hello:

I've this data:

and this expressions:

sum( { < Status = {'Delivered'} > } Amount )

sum( { < Status = {'Accepted'} > } Amount )

sum( { < Status = {'Lost'} > } Amount )

the results are the expected.

The problem is that I need to change the "Delivered" expresion to get only the last version of all status of each order.

Now for the Offer No 3, delivered amount is 2550 but the correct sum is 750

Please, could you help me to correct this expression: sum( { < Status = {'Delivered'} > } Amount )

Thank you

Re: Set Analysis help

swuehl — Thu, 17 Jan 2013 14:49:31 GMT

Try

FirstSortedValue({<Status = {'Delivered'}>}Amount, -[Date D/M/Y])

in a table with dimension Offer No. or, if you need a total line for that expression:

sum(aggr(

FirstSortedValue({<Status = {'Delivered'}>}Amount, -[Date D/M/Y])

,[Offer No.]))

Joaquin_Lazaro — Thu, 17 Jan 2013 15:34:04 GMT

Thank you very much, swuehl

I just used both with and without totals