2 Replies Latest reply on Nov 23, 2019 11:51 PM by Yuriy Fal

    Educational Brain Teaser : Empty Rows

    Yuriy Fal

      Hi friends,

       

      The #TC19 is over, and it's time for yet another EBT.

      This one is about filtering while preserving 'Empty Rows'.

      Like this:

      Screenshot 2019-11-23 at 17.04.42.png

       

      Please, make a guess what the [State Filter] would be?

       

      Definitely it's a Table Calculation (you see),

      so the right Addressing & Partitioning are

      as important as the calc (formula) itself.

       

      I would be happy if you could rank this Teaser

      (on a scale from zero to anything you want,

      though high five would be enough, imho :-)

       

      Yours,

      Yuri