Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All
I have a problem i cant understand why this happen require expert advise i have pivot table with no any selection the table give me the wrong figures of two columns like this
NUM | No. Of Disbursement | Last Disbursal Date | Last Disbursal Amount | Disbursement Amount | No. Of Withdrawal | Last Withdrawal Date | Last Withdrawal Amount | Withdrawal Amount |
789453 | 9 | 19-01-2015 | 0 | 34200 | 6 | 18-12-2014 | 0 | 32000 |
452125 | 11 | 18-12-2014 | 0 | 38400 | 5 | 18-12-2015 | 0 | 38000 |
548712 | 11 | 18-12-2014 | 0 | 38400 | 9 | 18-12-2016 | 0 | 38000 |
and when i select the list box num it give the the right figure
NUM | No. Of Disbursement | Last Disbursal Date | Last Disbursal Amount | Disbursement Amount | No. Of Withdrawal | Last Withdrawal Date | Last Withdrawal Amount | Withdrawal Amount |
124578 | 11 | 18-12-2014 | 4500 | 38400 | 11 | 19-12-2014 | 4500 | 38000 |
the num is mu dimenshion and remaining is my expressions..
Prompt response is highly appreciated
124578? Where it is?
Provide proper data to work..
this is dummy data just for understanding and i want the amount of last disbursal date.
Can you provide the result you are looking for based on the data provided?