Bringing the total number remains the same 22901814.
What is it?
The problem is surely related to your data association ...
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.
The previous post is correct. The chart dimensions to the dimensions must be included in the dimensions in the aggr statement.
Yes, that's right.
=sum(Aggr(sum([Количество реализации])*FirstSortedValue([Цена закупки], -[Дата цены]), id_Товара, id_Магазина))
works as it should. thank you very much.
Retrieving data ...