Create, using PivotTables in Excel, a contingency table showing "Total Deposits" in rows, versus "Loans and Leases" and "All Real Estate Loans" in columns as % of the column totals. Use a chart suitable for this question with concise formatting.

Total Loans and leases, All real estate deposits $ gross $ loans $ 127201 28676 15488 47082 47585 34715 100025 120047 109170 348485 348741 274897 121667 120844 100810 41303 38381 34081 433344 520068 470815 137092 182368 175772 203243 220958 200410 188415 234628 225586 1226276 1306493 1147526 817932 768141 646686 18726 6920 1250 782414 872772 815769 1607454 1446172 1008783 88503 66360 43800 169777 121464 113997 2167140 2203572 1681328 139233 122177 115816 567347 599253 554810 343452 398421 376297 4478432 4952826 4514494 665061 763800 669229 204178 170948 156778 727914 783517 768417 14563848 14372856 10243707 39136 26028 9206 1312502 0 0 285710 245248 235067 9956 867 454 1050254 1201924 1096005 332815 291974 263784 478719 530742 501797 624802 613783 577197 147194 84093 82651 67360 67770 60502 34880 21499 15386 157581 160249 156795 89641 81650 49969 559456 526263 490208 155028 107196 95170 31190 18141 11038 147352 156582 104812 348259 339476 277706 144945 152390 138550 364211 342657 337006 500 0 280230 302020 266109 88982 38569 35456 199755 178128 155038 610278 439057 428027 80614 71065 63690 420493 355298 332203 1031430 1367634 1299994 190046 164060 125117 12351758 12752426 9226014 265373 201356 188617 163706 159537 157491 201539 138536 115847 396430 377362 258421 71845 68385 65066 1978268 1978878 1881394 456865 474245 464824 510533 451204 391686 106293 93909 90685 210577 207082 173567 29153 28080 8855