Logic Calculation

[krish2459]

Hi,

We a have below requirement which was posted as image.

Actually I thought of instead of therotical explanation it very better to expalin with an example of what we need.

Please go thorugh with the image below and attached sample work book.

Thanks..

[krish2459]

Hi ,

Any Inputs to crack the logic.

Thanks..

[Anil_Babu_Samineni]

Perhaps this?

Count({<Product={"=Sum(Aggr(count(Product), Product))=$(=Count(Distinct My))"}>} Product)

[krish2459]

Hi Anil,

I'm getting blanks by using the logic you posted.

Thanks..