Hi
I have a dashboard that has revenue for different time periods, however in one of the charts the calculation must look at revenue for the current month and year and be able to filter down on selections.
sum({<Monthyear={"$(vcurrentmonthyear)"}>}Revenuesum)/1000
The problem i have is that if a user clicks a different month in the dashboard, the chart changes because of the $ expansion.
How can i force the expression to only look at the current month. If i take the $ out, the variable errors.
Many Thanks,
Simon
