3 Replies Latest reply on Sep 20, 2018 5:59 AM by Shinichiro Murakami

    Ranking based only on Max year on the filter

    jackyyeefa.tang

      Hi all,

       

      Currently stuck on a ranking question. Appreciate if someone can give me some directions to how to resolve this.

       

      Years in the table is dynamic, i.e. user can set the date range.

       

      I want the ranking to always be the "latest year" in the view. I.e. in here ranking on the 2017 figures only.

       

       

      Then when user setting the ranking number they want to see, i.e. 2, then only "Technology and Office Suppliers" will show up.

       

       

      What I wanted.

       

      Many Thanks !