Shorting issue

[vipin_mishra479]

Hi

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

[sridhar240784 · Accepted solution]

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]

thanks. Sridhar