5 Replies Latest reply on Jan 30, 2019 7:43 PM by paul.winiecki

    Last Non-Null Value in a Hierarchy

    paul.winiecki

      Hello,

       

      I have a Hierarchy that is set up as Color>Suit>Card in a Tableau 2018.3 packaged workbook. Some of the "Card" values are NULL. I would like to create a new variable where for those Card values that are NULL it would show the Suit, otherwise it would show the Color. I've tried creating calculated fields to accomplish, but I haven't been able to figure it out. Do any of you know of a way this could be done? For certain reasons, I can't have the solution to this be a Table Calculation either. Any help would be greatly appreciated. I've attached the packaged workbook in this post.

       

      Last Non-Null Value in Hierarchy Screenshot.jpg

      Thanks!

      Paul