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


      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!