Hi All,
We are working on a report that has a few different program_names
that are summed up in a pie chart using orig_loan_amount
.
I have been tasked with trying to sub categorize our bonds using a taxable/tax-exempt designation
The problem I am trying to overcome is that our bonds (identified by pool_name
) are actually made up of both. There is no designation on a single line.
So for example:
Loan number 157214's total loan amount was 373k+ - it was distributed into our 2024EF Bond. 40% of it is taxable and 60% is TE.
This would be pretty straight forward if I was only trying to show a breakdown of the bonds and what the taxable/TE amount was BUT those pool_names that have BOND in them get put into a program name that is bonds - and there are 3 other programs listed in our pie chart.
Essentially, I need this pie chart to show 60% tax-exempt and 40% taxable - just for the Bonds. AND I also have to show the GNMA MBS, the 'Blanks', and the FNMA/FREDDIE on the same visualization.
Is this possible?