I am computing the % difference in rebate for products quarter over quarter. I want to build a flag where the user can filter for products where a rebate existed in the current quarter but not the previous (vice versa). The "Flag" column below is what I am trying to build. The % of change is a table calculation based on Rebate. I'd like to show both quarters.
Apologies, but i can't send an example workbook. Please let me know if you can help or need additional clarification.