How can I calculate the increase in sales year by year?

[#1]

Dear,

I need help to calculate the increase in sales [Oportunidad.PrecioCliente] year by year [OpDetalle.FechaCierre.autoCalendar.Year] for each product. I have the following table:

I set the following function but it does not calculate any value

Sum({<[OpDetalle.FechaCierre.autoCalendar.Year]={[OpDetalle.FechaCierre.autoCalendar.Year]}>}[Oportunidad.PrecioCliente])/

Sum({<[OpDetalle.FechaCierre.autoCalendar.Year]={[OpDetalle.FechaCierre.autoCalendar.Year]}-1>}[Oportunidad.PrecioCliente])

How should I write the formula?

How can I calculate the increase in sales year by year?

Thanks!

[arulsettu]

try this

Sum({<[OpDetalle.FechaCierre.autoCalendar.Year]={$(=(max([OpDetalle.FechaCierre.autoCalendar.Year]))}>}[Oportunidad.PrecioCliente])/

Sum({<[OpDetalle.FechaCierre.autoCalendar.Year]={$(=max([OpDetalle.FechaCierre.autoCalendar.Year])-1)}>}[Oportunidad.PrecioCliente])

[ahaahaaha]

Hi,

May be

Sum([Oportunidad.PrecioCliente])/Above([Oportunidad.PrecioCliente], 1, 1)

Regards,

Andrey

[#4]

Thanks Andrey, but I need the increase year by year.

The formula performs the calculation only for the year 2017.

Is the table wrong how I designed it?

Año is a Dimension

Brand is a Dimension

Ventas is a Meassure

[#5]

Thanks Arul,

The formula does not return any results. Is the table wrong how I designed it?

Año(Year) is a Dimension

Brand is a Dimension

Ventas(Sales) is a Meassure