6 Replies Latest reply on Jul 10, 2016 2:39 PM by Chris Dickson

    Filter based on rank for current year only

    Paramdeep Khangura

      I've got a line chart with 2 points on the x axis, 2016 and 2015.

      My different lines are based on a dimension in my data.

      I have a parameter where I chose the top n items in the dimension based on the measure in my chart.

       

      I would like the parameter to filter based on 2016 only. I'm just not sure on the syntax. I know I can use a formula in the filter and assumed i'd need to use a lookup but that doesn't seem to be allowed in the filter top x formula area.

       

      Any help would be great. Thanks