Hi
I have two scorecards. One showing historical revenue and one showing last 12 months revenue. I also have a date range control. What i want is for both scorecards to filter with the date range control.
Ex - Date range filter is filtered to Month - July 2025
Scorecard 1 - July 2025
Scorecard 2 - Sum(July 2024-June 2025)
When I add a custom last 12 months filter to it. it doesn’t filter with the data range.
I’ve tried some custom formulas but no luck