Front End calculation

[MindaugasBacius]

Hello Community

I am facing some middle-week crises 🙂

Looks like a simple task, yet not able to crack it.

I have data from A:C columns and need a result in E:G.

Need a COUNT(DISTINCT SKU) according to the Supplier lowest Rating.

Supplier	Rating	COUNT(DISTINCT SKU)
A	1	20
A	2	11
A	3	12
A	4	13
B	3	14
B	4	15
C	2	16
C	3	17
C	5	18

Thank you guys!

[BrunPierre]

Hi, this should work.

=Count(Distinct If(Rating = Aggr(Min(Rating), Supplier), SKU))

[MindaugasBacius]

Sadly it's not working.

Any thoughts?

[BrunPierre · Accepted solution]