Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
try
Sum({<DIM={'2013*','2014*','2015*'}>}Value) as your expression
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)
Hi
i tried this but didn't work
=alt(Count({<Month_year={'2013*','2014*','2015*'}>} alt(CobranzasMonto,0)),0)