Dear Experts,
As per the requirement scenario 1, I need to show the Proposal_Date when the sum(Amount) was reaching 35K in one of the table chart.
Similary, In the scenario 2, i have to show the Received Date based on the same criteria.
Please provide your valuable inputs to achive the below expected results.
Expected results:
scenario 1:
Customer -> 110 Acheived_Proposal Date -> 22-04-2013
scenario 2:
Customer ->110 Acheived_Received_Date -> 30-04-2013
Data:
BillNo | Proposal_Date | Received Date | Amount | Customer |
1004 | 23-04-2013 | 23-06-2013 | 15000 | 110 |
1005 | 13-08-2013 | 13-08-2013 | 10000 | 118 |
1003 | 18-04-2013 | 29-04-2013 | 10000 | 110 |
1002 | 21-04-2013 | 30-04-2013 | 15000 | 110 |
1001 | 22-04-2013 | 21-04-2013 | 10000 | 110 |
Thanks in Advance
Bala