1 Reply Latest reply: Jul 20, 2015 2:32 AM by Liron Baram RSS

    N-Printing Filter Selection with aggregation

    Praveena Velagapudi

      I have below issue in n-Printing..

       

       

       

      Need to execute below expression to bring in this output in to  Year and Month filter selections

       

      Year:  aggr(max({<[KPI Type]={'Market Share'}Calendar Year]),[Europe Region])

       

       

       

      Month:  Date(aggr(Max({<[KPI Type]={'Market Share'}>}[Calendar Month And Year Number]),[Europe Region]),'MM')

       

      please find attachment..

       

      I can use ‘KPI Type’ as Market Share in selection. How can I aggregate with Europe Region? I tried to bring this in different ways but could not!!

       

       

       

      I need to aggregate it to Europe Region because I have different Months and Year for latest in a Region, please find below.

        • Re: N-Printing Filter Selection with aggregation
          Liron Baram

          hi you can do it

          but there is something odd with your filter it might result in an array and not a single value

          as you use aggr function

          any how you can do it like this

          in the year filter insert this

          =Year=max(aggr(max({<[KPI Type]={'Market Share'}[Calendar Year]),[Europe Region]))

          make sure you keep the evaluate or is numeric empty

          for the month

          =Month= Date(max(aggr(Max({<[KPI Type]={'Market Share'}>}[Calendar Month And Year Number]),[Europe Region])),'MM')