Formula/Calculation Help!!

[Anonymous]

Hi All,

Not sure if it's possible but I am trying to create a calculation where in I can view the average prices of each sub-type.

Condition:

-Table 1, 2, and 3 are connected together.

-All but one product is based on supplier 1 column. Tomatoes are based on supplier 2 column.

This is the visual that I want to show, but not exactly sure how to create a formula that would give me the correct values. It would have been easier if the they all have the same supplier just so that I can create a basic filter, but then it's complicated having multiple supplier column.

Many thanks,

Sub-Type	Roger + Roger/Rafa	Rafa + Roger/Rafa
Lettuce	g	b
Apples	o	e
Tomatoes	a	s
Carrots	t	t

---------------------------------------------

Table 1: Product

Type	Sub-Type
Vegetables	Carrots
Fruits	Apples
Fruits	Mangoes
Vegetables	Tomatoes
Vegetables	Lettuce

Table 2: Supplier

Supplier 1 (All Products)	Supplier 2 (Tomatoes Only)
Roger	Rafa
Rafa	Roger
Roger/Rafa	Roger/Rafa

Table 3: Price

Prices

5.50

3.20

1.16

3.14

[v-kelly-msft]

Hi @Anonymous ,

It's a bit confused : 1. what does the letters in the table mean?

2. How do the prices match the sub-category?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!