How to set the measures of a graph depending on filters

[jandro98]

Hello,

I need to show in a graph the number of Sales of a Year by month.

The problem is that i would like to show the years setted as filter.

Here I leave you an example of a hardcoded years.

I would like to show this but with all the years setted in filter

Is that possible?

Thank you.

[Vegar]

Try something like this. The example is assuming you want to calculate sum(Amount).

Sum({<DateField, yearmonth=, Year={">=$(=max(Year)-1)<=$(=max(Year))"}
>}Amount)