Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Find attached qvw file 2014 is @ the bottom because it started from May how do I bring it to the top and still have my month well arranged from Jan, Feb, Mar...
Regards
Ema
Hi,
Have you try it in sort tab.
add two sort
1 : Numeric Value -> Descending
2 : State-> Ascending
Regards
Try like :
Match(Month, 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec', 'Jan', 'Feb', 'Mar', 'Apr')
PFA. Hope it will help you.
Hello Max,
I have tried this
Hi,
PFA
Check this qvw
EDIT: Try this expr in sort
[Retirement Year] & Right('0'& match([Retirement Month],'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'),2)
try
If you want only current year to start from May , rest all from Jan then u can use the expression as
=If([Retirement Year] = Year(Today()) , match([Retirement Month],'May','Jun','Jul','Aug','Sep','Oct','Nov','Dec','Jan','Feb','Mar','Apr'),
match([Retirement Month],'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'))
Hello Patil,
Only 2014 should start with May. Other year are suppose to start @ Jan, Feb, Mar....
Hello CJ
Couldn't open urs