Hi Deepak, Thank you for your reply. I tried this but it doesn't work in certain cases. can you take a look at the attached screenshot and the sample workbook and let me know your thoughts.
I want it to say N but the calculated field I'm using is generating Y.
Follow this 2 Step Process for your attached Example:
- Add Ship Date to Context
- Use this Calculation
You would get this, so the values will change as you would change the Ship Date in Filter
The attached is in 10.4 but you just need to use the 2 steps as above.
Hope it Helps and If it does, Please mark it Helpful and CORRECT.
Test Workbook.twbx 1.1 MB