Calculate Value of last Order

[#1]

Hi all

with the formula max(Fact.Date_Ordered) I can calculate the date of the last order.

How can I calculate the value of the last Order?

The formula to calculate the revenue is  sum({<Fact.Type = {'Sales'}>}Fact.Net_Rev_EUR))

Thanks for your help

[tresesco]

Use FirstSortedValue(), like:

FirstSortedValue( Aggr(sum({<Fact.Type = {'Sales'}>}Fact.Net_Rev_EUR)), Date) , -Date)

[#3]

sum({<Fact.Type = {'Sales'}, Fact.Date_Ordered = {"=$(=max(Fact.Date_Ordered))"}>}Fact.Net_Rev_EUR))

[alexandros17]

try this and let me know

sum({<Fact.Type = {'Sales'}, Fact.Date_Ordered = {'$(=max(Fact.Date_Ordered))'}>}Fact.Net_Rev_EUR))

[#5]

Unfortunately all 3 suggestions doesn't work...

As Dimension I have "Customer_Sales.Name" in the Table.

[#6]

can you attach a sample app