5 Replies Latest reply: May 9, 2018 7:38 AM by Sunny Talwar RSS

    Set analysis

    Fernando Sevilla

      Hello!,

      I have a doubt with Set Analysis and iI'm going crazy, I hope you can help me !!

      I have a table like below:

       

         

      CountryModel20172018

      España

      V11003
      EspañaV22845
      EspañaV38057
      FranciaV14568
      FranciaV230026
      FranciaV3254

       

      I have Model, Year and country filters and I am trying to get a KPI using Set analysis writing a formula with dynamic filter to know the number of units in year (2017 or 2018) once I selected a country and a model in the filters. In the table are Spain, France but there are many other countries with the same models.

      I've been trying with: sum ({$ <Model = {"??"}>} [2017]).

      ?? My problem is that I do not want to fix the model in the formula, what I want is that every time that I choose a model using the normal filters the formula takes it to recalculate the KPI, for example let's say that I choose Model VN1 and country Spain then my KPI immediately shows me 100 (obviously for this example year 2017 would be part of the formula)

       

      It's possible?

       

      Kind Regards, and thank you very much

       

      Fernando