Get last loaded value by date

[#1]

Hello All, in QV I load different article prices in different time periods. Example;

In QV this is loaded as below;

What i want to do is in a QV Pivot table get the Min article price over YTD 2010, this I do as follows;

For reporting over period 2010-07

MIN (if (InYearToDate (TreatmentDate,'31-07-2010',[Price]))

And over 2010-05

MIN (if (InYearToDate (TreatmentDate,'31-05-2010',[Price]))

But I also want to get the last known price;

When reporting over period 2010-07, i want the result;

And reporting over 2010-05, I want the result

Can anyone help me out here?

Thanks in advance!

[#2]

Can anyone help me out here please, I'm stuck.

[#3]

Hi,

please see the attached example (Script).

Good luck!

Rainer

[#4]

This is a solution if you only want to see it for 1 date. But if you want to have selection possibilities for the date it is not working anymore

[#5]

anyone else another hint?

[#6 · Accepted solution]

I tried this with

FirstSortedValue(Price,-TreatmentDate)

I think it should be something like this, but above isn,t working yet. anyone a hint?

[#7]

Above is working now!!. I looked at aggregated level first, then the function runs into multiple values and it doesn't return anything, but if you go to n-level it is working fine