0 Replies Latest reply: Nov 9, 2018 5:20 PM by ŞAKİR ÇİMEN RSS

    filter column using set analysis

    ŞAKİR ÇİMEN

      Hello everyone, I am trying to learn this program but I am stuck somewhere, I read at least 20 topics but I seem to miss a point.

       

      I have a table like this:

       

      Col ACol B
      XX25
      YY30
      XX15
      YY40

       

      I am trying to filter them using Col B, and show the Col A data in a graph. But I can't apply the filter.

       

      To find the rows with Col B > 20, what should I do?

       

      I created a chart with Col A values, I click set analysis, and apply below func there but nothing changes.

       

      AGGR( ONLY ( {$<[Col B]={'>20'}>} [Col A] ) , [Col A]  )

       

      What am I missing?