How to compute aging by every 30days ?

[paulyeo11]

Hi All

I have Table

Dimension = Aging by day

Expression = Total Amount.

May i know how to use CLASS to break the Aging in below format ?

1-30

31-60

61-90

91-120

121-150

151-180

>181

Hope some one can advise me.

Paul

[paulyeo11]

My QVW FILE

[sunny_talwar · Accepted solution]

Not sure, but does this seem right?

[paulyeo11]

Hi Sunny

thank you very much for your help in make my chart look nice, and also help me modify the expression using match and pick. appreciated very much.

[sunny_talwar]

Do the numbers look right? Doesn't match what you have in the other chart.

[paulyeo11]

yes , of course. thank

[sunny_talwar]

Great