Shows Products purchased by more than one supplier

[#1]

Hello,

I wish to only show products that two suppliers are both purchasing.

Item	Supplier	Price
ABC123	SUPP ABC	14
ABC123	SUPP EFG	15
DEC123	SUPP ABC	12

I thus only wish to show the first two rows in my table.

So only show items which BOTH suppliers are purchasing.

[antoniotiman · Accepted solution]

Hi Chris,

maybe

Dimensions : Item,Supplier

Expression :

If(Count(DISTINCT TOTAL <Item> Supplier) > 1, Price)

Regards,

Antonio

[rubenmarin]

Hi Chris, another option is using calculated dimensions, in example:

=Aggr(If(Count(TOTAL <Item> DISTINCT  Supplier)>1, Item), Item)

or, if you want to ignore supllier selections:

=Aggr(If(Count(TOTAL <Item> DISTINCT {<Supplier>}  Supplier)>1, Item), Item)

Based on what you want at the end and the type of chart you should decide apply the filter in expressions or in dimensions.

[#4]

Thanks a bunch. I was missing out total!

[#5]

@antoniotiman How would I amend if I added in another dimension example . Item, Supplier, Maufacturer, Price

[antoniotiman]

You don't need to change.

[antoniotiman]

[#8]

Hello,

Sorry I meant If I wanted Manufacturer to be the first column.

[antoniotiman]

No change