|
Post by richardthe4th on Apr 4, 2017 12:42:06 GMT
Hello all,
Does anyone (preferably a Billy Whizz with IT) know if it's possible to sort out loans according to borrower ID on My Loans page. Or is there another way I can get this info...
Ta!
|
|
star dust
Member of DD Central
Posts: 2,998
Likes: 3,531
|
Post by star dust on Apr 4, 2017 12:56:28 GMT
Hello all, Does anyone (preferably a Billy Whizz with IT) know if it's possible to sort out loans according to borrower ID on My Loans page. Or is there another way I can get this info... Ta! No easy way that I've detected, paste into excel as text, muck around with to get all details on one row per loan part and sort. I and others have requested 'my loans' to be downloadable beforehand here, but so far no word from Collateral Rep - unless I've missed it.
|
|
elliotn
Member of DD Central
Posts: 3,063
Likes: 2,681
|
Post by elliotn on Apr 4, 2017 13:35:01 GMT
You could download your transaction data which separates borrower id and then pull out the elements you need in a pivot.
|
|
ozboy
Member of DD Central
Mine's a Large One! (Snigger, snigger .......)
Posts: 3,156
Likes: 4,830
|
Post by ozboy on Apr 4, 2017 17:00:45 GMT
Jesus, I'm going have to up the ante on my spreadsheet etc "skills", I've NO idea what or how a "pivot" is?!!
|
|
|
Post by eascogo on Apr 4, 2017 17:33:14 GMT
Jesus, I'm going have to up the ante on my spreadsheet etc "skills", I've NO idea what or how a "pivot" is?!! ozboy A few months ago I copied examples and instructions on this forum. Have forgotten who supplied them but you can search for that if you like. I haven't got very far with this but they should help. Also attached is a youtube link to lectures on the subject. pivot table instructions.rtf (1.86 KB)
|
|
ozboy
Member of DD Central
Mine's a Large One! (Snigger, snigger .......)
Posts: 3,156
Likes: 4,830
|
Post by ozboy on Apr 4, 2017 17:37:50 GMT
Merci eascogo!
|
|
Neil_P2PBlog
P2P Blogger
Use @p2pblog to tag me :-)
Posts: 355
Likes: 209
|
Post by Neil_P2PBlog on Apr 4, 2017 17:55:25 GMT
If you use excel at work, adding in a pivot, a couple of slicers and colouring the sheet white is an easy way to make anything look impressive in 5 minutes :-).
|
|