Front End Calculations SET, AGGR, IF?

[MindaugasBacius]

Cheers people

I am facing an issue while trying to calculate this on the front end this type of results.

The income data is A:C - result E:G columns.

I need to COUNT the DISTINCT number of Barcodes according to the Manufacture minimal Rating.

Manufacturer	Rating	Barcode
A	1	1
A	1	1
A	2	3
A	2	4
A	4	5
B	2	6
B	2	6
B	2	8
B	3	9
C	1	10
C	2	11
C	3	12

Thank you in advance for helping me out!

[M_L]

This should work:

sum(aggr(min(Rating),Manufacturer))

You can hide 0 values from your table, or exclude them in your expression if you don't want to see them in your table.

[MindaugasBacius]

Yet I need COUNT IDTSINCT of Barcodes.

[vinieme12 · Accepted solution]

As below

=Count(Distinct Aggr (if(Rating=min(total <Manufacturer> Rating), Barcode),Manufacturer,Rating,Barcode))

[MindaugasBacius]

@vinieme12 you're a champ! 🙂