Previous and Current Month data comparison

[#1]

Hi,

Please assist as I want to perform the following  computation:

on my data set I have a field 'class' the holds two outcomes 'legal' and 'not legal'

I want to sum the total amount when:

- in the previous month, the accountNumber's class was 'not legal'

- and current month, the accountNumber's class is 'legal'

meaning i want to sum total amount for only the accountNumbers that have transitioned from not legal (in the previous month) to legal (current month)

Your assistance will be highly appreciated

[Gysbert_Wassenaar]

Please don't clutter this site with duplicate discussions: Previous and Current month comparisons

[#3]

Good day,

Could I please get assistance...