Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
thanks. Sridhar