6 Replies Latest reply: May 31, 2018 9:58 PM by vidya sagar malla RSS

    How to assign drop value to a variable?

    vidya sagar malla

      Hi,

       

      Hope you guys are doing great. I want to assign a drop-down value to one of the rank expression.

       

      Load Script:

       

      Rank_Table:

      load * inline

      [

      dim,Rank

      Top5,5

      Top10,10

      Top15,15

      Top20,20

      Top25,25

      ];

       

      Drop Down: So when I select Top5, 5 has to apply to the below dimension expression.

      dropdown.png

       

       

      Dimension Expression:

       

      =if(aggr(rank(sum(FUNDBALANCE)),PLANYEAR,COMPANY)<=VARIABLE,aggr(rank(sum(FUNDBALANCE)),PLANYEAR,COMPANY))

       

      Thanks in advance!!