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

    Educational Brain Teaser : Top N Customers by Year

    Yuriy 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":

      https://kb.tableau.com/articles/howto/finding-the-top-n-within-a-category

       

      "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

       

      Yours,

      Yuri

       

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