Doubt about one dimension

[#1]

Hi.

I have the field

YEAR - MONTH as dimension in one graphic. but i have year from 2005 to 2015 and i'd like to use only from 2013 to 2015.

I tried a if(not(isnull but when i use that a lot of values dissapear.

Any ideas?

Thank you

Greetings!

[#2]

Hi Jeremias,

do you just want the last two years to show in a listbox? or is this a chart?

In a chart I would recommend using set analysis in your expressions so the chart only evaluates for the years you want.

If you want this as a limit in your listbox, then create the listbox as an expression and set the criteria in there

i.e listbox as expression if([YEAR - MONTH]>='201301', [YEAR - MONTH])

hope that helps

Joe

[Clever_Anjos]

try

Sum({<DIM={'2013*','2014*','2015*'}>}Value) as your expression

[#4]

Hi.

is a pivot table

i dont wanna have all those years with null values.

My expression is this alt(Count( alt(Money,0)),0)

I tried this but didn't work

=alt(Count({<Month_year={'2013*','2014*','2015*'}>} alt(CobranzasMonto,0)),0)

[#5]

Hi

i tried this but didn't work

=alt(Count({<Month_year={'2013*','2014*','2015*'}>} alt(CobranzasMonto,0)),0)