Shown a diagrame with residual values in percent

[Semiro]

Hello,

Is it possible to display a diagram with residual values as a percentage with the specified data:

Make	Model	Year (manufacturing year)	Date (Sold)	Listprice
Audi	A3	2000	2017-05-20	120000
Audi	A4	2002	2018-06-13	175000

And how the different cars depreciate in value each year of the cars age, up to the age of 10 years.

I have tried something like this:

If(Count(total <Make,Model> ListPrice),
  Sum(ListPrice)/(((YearSold)-(Year))/10)
)

where YearSold is an "excerpt" of "Date"

date,
Year ([Date]) AS YearSold,

What am I doing wrong and how should I think?
Thanks in advance!

[Taoufiq_Zarra]

can you share a sample data and the output expected ?

[Semiro]

Hi Taoufiq ZARRA,

The output should be something like this:

[Taoufiq_Zarra]

can you further develop your need?

and provide a sample data to be able to give the exact solution.

[Semiro]

This is a sample data:

Make	Model	Year (manufacturing year)	Date (Sold)	Listprice
Audi	A3	2000	2017-05-20	120000
Audi	A4	2002	2018-06-13	175000

My further develop is how to show residual value over a 10 year period. Don't know how to explain it better.