Maximum date

[#1]

Hi,

I have two partners in my dataset, i need to consider the latest transaction date in a week and its corresponding sales value.

Thank you.

[Anonymous]

you can use expression as :

sum({$<[Transaction Date]=$(=date(max([Transaction Date])))>}Sales)

Please note [Transaction Date] should be in date format or you can use this field after converting it to numeric values and then use it.

[#3]

Take week as dimension, and try to use expression:

firstsortedvalue(distinct sales,-transaction_date)

Let me know if it works.

regards

Darek