3 Replies Latest reply on Nov 26, 2018 3:57 AM by Yuriy Fal

    CONVERT INTERMEDIATES PRODUCT VALUES TO UNDERLYING INGREDIENTS - help!

    Cristiano Nardocci

      In our supply chain we can use either basic ingredients or other finished or semifinished product to produce a final product that we sell. So the situation is similar to what I've included in the excel example file.

      What I'm not able to figure out is how I get Tableau / Tableau Prep to recognize when we are using a finished / semifinished product as ingredient for a different finished product and replace that value with the basic ingredients which are behind the finished / semifinished used as ingredient.

      Any help?

       

      Thanks!!