sales with latest date

[Anonymous]

Good day.

My problem:

There is pivot table "Quantity with latest date" in attached model

In expression i calculate max date for each sales point, where total quantity >0

In second expression i want to show quantity with date, got in first expression.

Thank you!

[Yousef_Amarneh]

but there are 2 product types for Point3, do you want only the max date of spoint regardless the product type?

[Anonymous]

yes.

i want to show quantity by max date.

max date must be the same for each product type.

thank you!

[Yousef_Amarneh]

I found a solution but in the load script, please see the attached.

[lironbaram]

hi have a look at the attach example

hope it what you looked for