Last Date Value

[#1]

Hello,

I'm looking for a funktion that selects the value form the last Date entered. I give you an example:

My table looks like this

Part Warehouse Date average price amount

1 10 01.01.2005 2,57 2000

1 10 02.01.2006 2,59 1000

........

1 10 27.10.2009 2,89 1000

I need the following output:

Part Warehouse Date average price amount

1 10 27.10.2009 2,89 1000

Thanks a lot for your help

[#2]

Hi,

see the example.

I hope you are looking for this kind of solution.

Good luck!

Rainer

[#3]

That kind of solution is exactly what I am looking for. I just would like to have that funktion in the object instead in the script. Is there any possibility?

Thanks

Ulrich

[#4]

Hi Ulrich,

see the modified example.

Add a calculated dimension in your table and it works.

But, if you are working with a large data volume the performance will be slowed down.

Rainer

[#5]

A possible alternative is to use a set analysis modifier.

Only({<Date = {"=Max(Date)"} >} Amount)

This means "get the amount column, but only having filtered the date column so it's equal to the maximum date".

Hope it helps.

[#6]

The Funktion is what I am looking for. All I have to do is to select the Value of the Field "Turnover" at the max date. I don't want to see the sum of that field.

All I need is a row with the Inventory from the 14th Sept 2005. (the table is a lot bigger but I hope with this information I will get it done by myself)

[Anonymous]

thanks to Rainer Filoada. I also use this solution.