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

    filter column using set analysis


      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


      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?