6 Replies Latest reply on Oct 22, 2019 2:11 PM by Yuri Fal

    Educational Brain Teaser : Top N Customers by Year

    Yuri Fal

      Hi friends,


      Teaser again, this time about finding Top N Customers within each Year.


      "Pizza cake, bro" -- one could tell -- "just take a look there":



      "Not so fast, pal" -- you may tell -- "how about this?"

      Screenshot 2019-10-03 at 13.50.45.png

      No Table Calc pills -- no INDEX(), no RANK(), no nothing.

      There is a Set pill on Filters (not a Table Calc based one).

      And the Grand Total looks as expected.


      Hope you'll find the teaser entertaining enough.

      If not (enough), you may have a bonus track ;-)

      Screenshot 2019-10-03 at 13.52.23.png





      PS  I'll be back with the answer at the end of next week.