It is a straight table, not sure exactly but what you mean with the sum for total mode. I am attaching a reduced model for you. You will see there is an opening balance which is the previous months closing balance. I brought this in to calculate the Reduction column. I get this data from the previous1 column. It works perfectly if I do a chart per ageing period, i.e. 120, 150, 180, but No I am trying to get smarter code and have one chart instead of three. The other code you gave me for this is in the Actual column. That works perfectly as well.
Hope I am not just missing something silly, or making a obvious mistake.
Compare the first and second straight table for Ageing History Performance 120Days+, the first one has the correct values
If you need to have a look at the code behind it the hidden script password is Qlikview