cancel
Showing results for 
Search instead for 
Did you mean: 

Ageing analysis in ISU

former_member344586
Participant
0 Kudos

Hi ,

  I need to display the report in the below format in report :

 

 

  Customer

  180 Days

  180 Days

  150 Days

   120 Days

  90 Days

  60 Days

30 Days

Current

  Balance

  I have got the document date in the extract.

could you please let me know how to design this logic.

View Entire Topic
Former Member
0 Kudos

Hi Raju,

you can create a Restricted key figure / Selection to achieve the buckets (days)

Restricted key figure -- drag and drop key figure (ex: total) ->then document date, now restrict the document date with variable range using offset values . you can use the standard variable 0DAT (current date) when applying offsets.

ex: 0Dat-30 to 0dat . this give the the value of last 30 days. similarly you can apply it for other days.