value with last date

[#1]

hello community,

I want to figure out the the up-to-date value, so the the value with the last date and put it in a pivot table.

So I have an article with a few dates and a different price behind it.

I want to have the price from the article with the last date. I know it sounds pretty simple but i can't do it.

Please let me know which date format I have to use

thanks

[er_mohit]

hii you can do this by using firstsortedvalue concept

see the attached file

[#3]

try this

Dimension--Date

Expression---

Sum({$<Date={"=$(=Max(Date))"}} Price)

or try this

try this

Dimension--Date

Expression---

Sum({$<Date={"<=$(=Max(Date))"}} Price)

[#4]

I want as dimension jus the articles and as formula the updatet price.

I tried the first sortet value concept and with a few exceptions it works.

the formula Sum({$<Date={"=$(=Max(Date))"}} Price) doesn't work in my case sorry

[#5]

Can I also do a total sum of

FirstSortedValue([MCHEAD-1.KOCSU1],-[MCHEAD-1.KOPCDT])

??