on 10-20-2015 4:42 PM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
9 | |
9 | |
7 | |
7 | |
7 | |
7 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.