This content has been marked as final. Show 4 replies
I have a dataset of Debtors. Two tables or sheets are there first is Invoice table which consists of invoice amount & credit notes raised on individual invoice no. and the second is Collections which consists of collection done on particular invoice no.
1.) To calculate the outstanding amount :- which I did by using the Set analysis on the frontend. now i want bucketing on the outstanding amount but i am not able to do that because i have not calculated the outstanding amount on the backend & Set analysis only works on the frontend. So can You please suggest how can i do bucketing now.
I have attached My App and the dataset below :-
i want this type of bucketing :-
Can anyone please help me in this...