Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Take week as dimension, and try to use expression:
firstsortedvalue(distinct sales,-transaction_date)
Let me know if it works.
regards
Darek