Master item without filter impact

[mauvasco62]

Hi all,

i need your support.

I would like to create a master item but if i select in my dashboard a period filter (for example a month) but don't want the report apply it . (my english is bad).

This is my master item:

SUM({$<[Fact type] = {'Fatturato'}, [CALENDARIO.Anno] = {'$(vCY)'}, [CALENDARIO.ReferenceDate_Julian] = {"<= $(vToday)"}>} Valore)

where vCY is a variable (current year

So if i filter month = march i would like to see (for a specific report) all year (including march).

Thank you in advance for your help

Mauro

[Fernando_Fabregas]

Ciao Mauro. Try this: 

SUM({$<[Fact type] = {'Fatturato'}, [CALENDARIO.Anno] = {'$(vCY)'}, [CALENDARIO.ReferenceDate_Julian] =

{"<=$(=Date( RangeMin( Max(YourMonth), vToday ) ) )"}>} Valore)

to get the minimum value between your selected value and today.

Depending on your data model, probably you must to convert YourMonth to the last day of month using MonthEnd().

Regards! Fernando