1 Reply Latest reply on Jul 22, 2018 3:29 AM by Chris McClellan

    Adding a calculated field to identify products

    melaniedddd

      Hi everybody,

       

      I'm currently working on different excel sheets which have this kind of structure :

       

       

      Obviously, I can't work with this chart without doing modifications.

       

      I would like to obltain this kind of view to work on Tableau Software to make analysis.

       

      I tried to do it with "code 1" and "code 2" which are numbers with a "isnull" and "previous_value" formula, but didn't work. Any idea ? Hope it's clear !!

       

      Many thanks!

       

      Best regards,

       

      Mélanie