Set analysis (Month)

[Anonymous]

Hi,

It is possible with set analysis to select from January to the current month selected? For example, if I select 'April' in field Month, my chart will display from January to April.

I tried different things but I couldn't do it. Can anybody help me?

Thanks in advanced.

Daniel

[giakoum]

see attached

[tresesco · Accepted solution]

Try like:

sum([$<DateField= {">=$(=YearStart(max(DateField))) <= $(=max(DateField))"}>} Amount)

[Anonymous]

Sorry I thinkt that I don't explained very well.

I want that in my chart if I selected April in field Month, chartt will display from January to April. So, dimension in my chartt is field Month. It is possible to do this with 'Calculated Dimension'?

[Anonymous]

This works for me.

Thanks to everyone for your help.