Forum Discussion

RaedHussein's avatar
RaedHussein
New Member
5 years ago

Calculated table from 2 sheets with working filters

Hi guys, I have an excel sheet that contains 2 tables, one for the Product Material Cost, and the other for Sold Product, like this Product Name Material Required Cost Product 1 Mate...
Need Help
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Hi, RaedHussein 

I am not sure about how your whole data model looks like, but I think there is some missing information in the sample.

Sales for Product 1 -> what is the material? is it wood, or is it Iron?

Sales for Product 4 -> I cannot know the cost based on the sample.

 

Thank you.

 

  • RaedHussein's avatar
    RaedHussein
    New Member
    5 years ago

    Hi Jihwan_Kim ,

    That was just an example, but we can say that Product one made from wood and iron and other kinds of materials, so the cost of Product one should be the Cost of wood + the Cost of iron