Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
PFA.
I want to show
YTD 5 2013 after year 2013 as i am using below calculated dimension.
=if(MONTH=5, 'YTD'& ' ' &MONTH& ' ' &YEAR,if(MONTH=1 or MONTH=12,YEAR))
can you please suggest how shall i go ahead.
thanks
Hi Tibhe,
try using this function in calculated dimension
=if(YEAR>=2013, 'YTD'& ' ' &MONTH& ' ' &YEAR,YEAR)
hope it will help
Regards,
Suryanto
Hi,
Is this your requirement?
Hi
I do not think it is possible as the dimension is showing the data at the end of each year and may comes before december.
Sasi
Hi Deepak
You can try this :- In Sort Tab
Expression :- Ascending
( match(YEAR,'1995','1996','1997','1998','1999','2000','2001','2002','2003','2004','2005','2006','2007','2008','2009','2010','2011','2012','2013','YTD 5 2013','2014','YTD 5 2014')
)
Text :-
A -> Z
Hope this helps. ( Don't Forget to hit " Correct Answer " Button, if you got your solution )
Regards
Ahmed.
Hi,
PFA - .qvw file. Also find the screenshot. Hope that helps!!
Thanks!
Hi Tibhe,
if it's about the filter problem then, try to change the sorting expression into this one
IF(YEAR<2013, YEAR, IF(YEAR>=2013,MONTH & YEAR))
Regards,
Suryanto
Hi Suryanto,
It is working as per requirement can you please suggest how to make this synamically when same conditions occurs in future.
thanks