snusseri
Data Storage
Joined 3 years ago
User Profile
User Widgets
Contributions
YTD calculation by any date selected on a date filter
Hello, I have a basic requirement but I am not sure how to implement it. My dashboard shows sales by a filtered time frame (can be Month, Quarter OR year). To the Total Sales widget (attached below) I would like to add, on the secondary measure, the Year-To-Date total sale according to the year selected in the date filter. I would like it to be dynamic as follows: If the user selects 'Q4-2023' I would like to show, on the secondary measure, the total 2023 sales. if the user selects Q2-2022' I would like to show,on the secondary measure, the total 2022 sales. Please note, that the date filter is a dashboard filter that impacts all dashboard widgets. *In the screenshot attached I was able to use a formula filter but on a predefined year, Its not dynamic. Please help. I am sure someone already encountered this basic requirement. Thanks Sagi1.4KViews0likes1Comment