Sumif question (dynamic ageing)

[Anonymous]

How to calculate the sum of the "Amount" field based on the number of delinquent days, grouped by month.

Please see below

Table fields

Amount     1/14     2/14     3/14     4/14

$100          4          34          64     90   

$80          45          65          71     85

etc.

Desired output chart

Month     0-30     30-60     60-90

1/14        $100     $80      $0

2/14        $0        $100     $80

3/14        $0        $0         $180

4/14        $0        $0        $180

What should be the dimension and expression ?

Thank you

Bassam

[marcus_sommer · Accepted solution]

It looked that you need to transform your data into a normal data-structure per The Crosstable Load and then you could use Month and class(aggr(sum(Amount), Month), 30) as dimensions and sum(Amount) as expression.

- Marcus