Calculated measure question
Summary:
Building multiple columns based on aging
Content (required):
I have defined a report that gives me the amount due on an invoice and it's related aging value.
I want it to end up displaying the aging columns based on rules... i.e.
CURRENT - <=0, 30 DAYS >0 and <31, etc, etc
So the results should look something like this:
SUPPLIER SUPPLIER TYPE SOURCE INVOICE TYPE INVOICE NO INV DATE CURRENT 30 DAYS
AAA INTERNA SUP MANUAL STANDARD EDB_Aarn(1) 12/8/2022 100
BBB INTERNA SUP MANUAL STANDARD EDB_aashe(15) 12/14/2022 10
TEST INTERNA SUP MANUAL STANDARD Test1 12/14/2022 500
What do I do to achieve this? How do I build those extra columns using my amount due and age columns?