Time Sensitive Exception Worksheet
We are trying to create an exception worksheet where time bucket is 4-4-5 and we are bringing 6 months data from the current date. We are trying to set an exception where (booking quantity-forecast quantity) is above a certain percentage. For this calculation we have created a custom series as well,
However, if we apply the exception and rerun the worksheet then it is fetching the data for which that was exception is met any of the previous 6 months instead of just in the previous month.
For example, for item A, following is the percentage values for each month and the exception is above 120%