Only the most recent line

[JoepF2]

Hi,

Excuse me if I might have used the wrong location.

My question is about three dimensions which show the price of the rentalcontract over the years. My wish is that the dimensions only show the most recent year/pricerow, which is €61.211,04, €193,20 & €61.404,24. (see picture below). Now it shows all of the price history, but I only want the most recent (or current) price.

What is the most efficient way to generate this wish? I have little to less experience with programming. What information do you need from me to generate the formula?

Thanks in advance.

[Gabbar]

Knowing the names of column would help a lot,
but let me try here
these are prices so lets name these three field A,B,C
Now these are prices of something  suppose that thing details is in Field D (These can be multiple column rather than single you can consider all of those merged here using '&')
Now as you have asked for latest Price only then there must be date field in the Table lets name that column F.
So try this:
Table1:
Load A,B,C,D,E ,A&E as Key from Source;
inner join
Load A&E as Key;
Load A,max(E) as E resident Table1 group by A; 

[JoepF2]

Hi @Gabbar ,

Thanks for replying.

The first column is called: =[Aanhuur.NettoHuur]
The second column is called: =[Aanhuur.Servicekosten]
The third column is called: =[Aanhuur.BrutoHuur]

The columns are indeed linked by a date field, which is called: =[Aanhuur.DatumVan]

Could you perhaps repeate yourself and the steps with the column names?

[Gabbar]

there must be 1 more column, These are prices of something(like Bread,Electronics etc) what is the name of that column.

[JoepF2]

@Gabbar 

It's linked to the column: =[Huurinfo.Huurcontract]. It's the contractnumber.

[Gabbar]

Are all these field same table,
Please add a snapshot of Table of all columns .

[JoepF2]

No it's not.

Here's the snapschot:

[Gabbar]

Snapshot of table as sample data, Not load editor,:
Let me try again :
The field name is Objects whose prices are given for different time period.
Now:
Table1:
Load Objects,[Aanhuur.NettoHuur],[Aanhuur.Servicekosten],[Aanhuur.BrutoHuur],[Aanhuur.DatumVan]
,Objects&[Aanhuur.DatumVan] as Key from Source;
inner join
Load Objects&[Aanhuur.DatumVan] as Key;
Load Objects,max([Aanhuur.DatumVan]) as [Aanhuur.DatumVan] resident Table1 group by Objects; 

This Data is of something, (Mostly The primary key of table).