Dyanmic Chart values

[#1]

Need to create one more column with value of ageing

over 150 has  value ,so create one more column with value as over 150

like  I have a chart with list of value on Ageing (i.e. total, Not Due ,0-30, 61-90)

customer No ,customer Name, chain, total, Not Due ,0-30, 61-90

1                         ,A                    ,MM    ,0       ,11         ,0     ,0

2                         ,B                    ,UU     ,0       ,0          ,0     ,669

3                         ,C                    ,XX      ,0          ,0         ,48,     0

then output table should include one more column Description with value of ageing having data

customer No ,customer Name, chain, total, Not Due ,0-30, 61-90, Description

1                         ,A                    ,MM    ,0       ,11         ,0     ,0,     Not Due

2                         ,B                    ,UU     ,0       ,0          ,0     ,669     ,61-90

3                         ,C                    ,XX      ,0          ,0         ,48,     0     ,0-30

[tamilarasu]

Check the attachment (Is this you want!!) and let me know.

[Kushal_Chawda]

you can create the expression something like below

if( Expression of Not due >0, 'Not Due',

if( Expression of 0-31 >0, '0-31',

if( Expression of 31-60 >0, '31-60'

.

.

.  )))

[Anonymous]

I would suggest go with cross table load you will get Description column values.

Thanks

BKC

[#5]

dear Khush,

Not Due ,0-31 ,31-60 and the value of field ageing with cross table structure

[sujeetsingh]

Not able to get what you want?