Hi, I have both MTD sales and monthly forecast data. They both have filters as you see below in order to be able to select and view any date on the list.
Now, I want to be able to divide MTD sales number by monthly forecast number to show how we are doing compared to forecast in terms of %. How can I create this calculation and also be able to show previous comparisons? So for example, if I want to see the percentage of past July 2018 MTD sales vs July 2018 monthly forecast, can I create a filter to do so. Thank you