Calculating price difference between suppliers

[AbbasG]

Hello All,

I have the data where I have the prices from different suppliers as below.

I want to display the Model number in a separate table where the Price of supplier 1 is at least lower by 10% as compared to the other 4 suppliers.

Model	Description	Supplier 1	Supplier 2	Supplier 3	Supplier 4	Supplier 5
A	test product	$160	$145	$130	$180	$140
B	test 2 product	$220	$185	$195	$180	$220

[AbbasG · Accepted solution]

@lbendlin I got the solution.

First I calculated the Minimum price. Then I added the Price difference measure compared to the minimum price.

Thank you for your effort.

[AbbasG]

@lbendlin Thank you for the reply.

Let me try to explain it again. The sample data is correct as below.

Model	Description	Supplier 1	Supplier 2	Supplier 3	Supplier 4	Supplier 5
A	test product	$160	$145	$130	$180	$140
B	test 2 product	$220	$185	$195	$180	$220

Now, I want to compare the price of supplier 1 with other suppliers.

If the price of supplier 1 is lower by at least 10% as compared to other suppliers, I want to highlight that Model no.

Thank you in advance for your kind help.

[AbbasG]

@amitchandak @Pragati11 If you guys help me with this, please?

[lbendlin]

Your sample data does not support your problem description.  Please provide sample data that fully covers your scenario.