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!
See attached. Look at the filter calc I made.