1 Reply Latest reply on Jun 6, 2018 11:17 AM by Joe Oppelt

    Applying an opposite filter based off the result of the table calculation

    Yang Yang

      Hi!

      I am trying to understand is there an easy way to do the following task, but I failed to find any solution after searching in the forum... Here it goes.

       

      I attached a sample workbook. I applied Calculation 1 to calculate the percentage differences of each year compared to 2014, and Calculation 2 is just an average of those percentage differences in Calculation 1.

      I am trying to create a filter (or something) to show all the cities with positive values in Calculation 2 in Illinois and all the cities with negative values in Calculation 2 in Washington. However, I do want to keep this display in one single table. Does anyone know there is a straightforward way to do so?

       

      Thank you so much!

      2018-06-06_9-20-04.png