Assortment matrix

[kolov007]

Hello.

I have a problem. I need to count the number of unique items in each store, thus it is necessary to consider only those products whose number is greater than 0 (>0). The document, which is attached as an attachment, at the level of display products level everything works right, but to collapse the network level, the data is displayed incorrectly.

Help me please to solve this problem.

[sunny_talwar · Accepted solution]

Try this:

Sum(Aggr(If(Sum(Amount) > 0, Count(DISTINCT Product)), Product, Shop))

[Anil_Babu_Samineni]

May be use this

Sum(If(Sum(Amount) > 0, Aggr(Count(DISTINCT Product)), Product, Shop))

[kolov007]

Thank you