15 Replies Latest reply: Nov 17, 2017 5:10 PM by sam pusala RSS

    Set Analysis with rank and filter

    sam pusala

      I am trying to add filter along with rank as below seems syntax is correct but I am not getting expected results any help?

       


      Count({<[Investment Strategy] = {"=Rank(Count({<Type = {'RFI','Database Search','Database Search Follow-Up'},Quarter={'Q1','Q2','Q3'},Year={""$(=Max(Year))""}>} [Investment Strategy]))<11" } > } [Investment Strategy])