Shorting issue

vipin_mishra479 — Sat, 30 Mar 2013 06:50:10 GMT

I have use this dimension in my pivote table

=If(((date(vDATE,'DD-MM-YYYY') - NETDUEDATE) >=0 and (date(vDATE,'DD-MM-YYYY') - NETDUEDATE) <=30),'0-30',

if(((date(vDATE,'DD-MM-YYYY') - NETDUEDATE) >=31 and (date(vDATE,'DD-MM-YYYY') - NETDUEDATE) <=60),'31-60',

if(((date(vDATE,'DD-MM-YYYY') - NETDUEDATE) >=61 and (date(vDATE,'DD-MM-YYYY') - NETDUEDATE) <=90),'61-90',

if(((date(vDATE,'DD-MM-YYYY') - NETDUEDATE) >=91 and (date(vDATE,'DD-MM-YYYY') - NETDUEDATE) <=180),'91-180',

if(((date(vDATE,'DD-MM-YYYY') - NETDUEDATE) >=181 and (date(vDATE,'DD-MM-YYYY') - NETDUEDATE) <=365),'181-365','>365')))))

and its show in this way

>365

61-90

0-30

91-180

31-60

181-365

But i want to short this

0-30

31-60

61-90

91-180

181-365

>365

please hep it how to short them

Re: Shorting issue

sridhar240784 — Sat, 30 Mar 2013 06:57:54 GMT

This could be achieved using dual function.

Your expression should be some thing like below

If(expression <=30,dual('0-30',1))

When you use dual function , your manually defined field could be sorted with the numerical sorting

Hope this helps you.

-Sridhar

vipin_mishra479 — Sat, 30 Mar 2013 07:04:03 GMT

thanks. Sridhar