Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have a formula like this:
sum({<Year={'2020'},Month={'July'}>} Sales).
Currently, if I select Year = 2020 and Month= August, the result turns 0. How can I make the result fixed and don't change with the filters?
Thank you in advance!
sum({<Year,Month,Year={'2020'},Month={'July'}>} Sales).
Your selections should not give you a zero result. Are you sure that you are not making any other calendar dimension selections, like in a Year-month field or similar?
If you are making such selections then you will need to cancel them out in your set expression like this.
sum({<[Year-month], Year={'2020'},Month={'July'}>} Sales)
Good luck solving your issue.