Determination of the average price for the maximum date

[kolov007]

Hello

I need to determine the average price of the product to the maximum (last) date of purchase of each product. And at the exit to get a table: Product, max(date), price. If it is a hard task, is it possible to make at least the following table: product, price

Help please, I will be very grateful

[swuehl · Accepted solution]

For max date, use an expression

=Max(Date)

and for average price on that date:

=FirstSortedValue(Aggr(Avg(Price),Product, Date) , Aggr(-Date,Product,Date))

[kaushiknsolanki]

Hi,

Have a look at the application.

It is not possible in chart because chart will find the max at overall level, but not at dimension level.

I have done some changes in script and then its done.

Regards,

Kaushik Solanki

[sathishkumar_go]

Hi,

Are you expecting the below value?

use avg(Price)

-Sathish