AGGR function changes the value after changing the sorting table

[vtatarnikov]

Hi!

but

Bringing the total number remains the same 22901814.

What is it?

[alexandros17]

The problem is surely related to your data association ...

[#3 · Accepted solution]

Hi,

i'am not sure what is it, but try to add your chart dimension into aggr () dimensions.

And maybe you may share sample allowing us to replicate problem and have a closer look on it.

regards

Darek

[jonathandienst]

Hi

The previous post is correct. The chart dimensions to the dimensions must be included in the dimensions in the aggr statement.

HTH

Jonathan

[vtatarnikov]

Yes, that's right.

=sum(Aggr(sum([Количество реализации])*FirstSortedValue([Цена закупки], -[Дата цены]), id_Товара, id_Магазина))

works as it should. thank you very much.