I have a chart which displays both the sales and the budget figures. What I want to do here is if a particular date is selected then the sales should change but the budget figures shouldn't change. I can't achieve this using the following set analysis expression.
I have attached the file. Can you kindly help?
Regardless of whether a sale has happened or not the budget value set should still come out in the chart. That is the requirement.