Pivot Table % range changes when Period is selected
Hoping you can give me a hand with this issue.
Trying to fix up an issue with the % Above and % Below Cost that changes when a Period is selected, because the Average Cost changes between when a Period is selected or not, as it takes the average for the year when no periods are selected instead of taking the average cost for the month.
The expression used is as follow:
- When No periods are selected:
- When a Period is selected: