cancel
Showing results for
Did you mean:
Frequent Visitor

## Formula/Calculation Help!!

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
Community Support

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

Announcements

#### Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.