Spreadsheet: 877544d1724343677-merging-two-pivot-tables-bauxn-book1
Sheet: Pivot

 |  |  |  |  |  |  |  | Industry/Code | Industries | Sum of Loss | Percent of Loss | Sum of Amount | Sum of Premium
Row Labels | Count of Industry | Sum of Loss | Percentage of Loss
1 | 10 | 7410.238871197522 | 0.3366491022317189 |  |  |  |  | 1.1 | 2 | 1715.079905381785 | 0.07791653149625562 | 27 | 72751.43670593218
1.1 | 2 | 1715.079905381785 | 0.07791653149625563 |  |  |  |  | 1.2 | 2 | 1094.883634064815 | 0.04974085165982727 | 21 | 74702.67475347099
1.2 | 2 | 1094.883634064815 | 0.04974085165982728 |  |  |  |  | 1.3 | 2 | 1606.447933391272 | 0.0729813524176954 | 20 | 75773.39892424161
1.3 | 2 | 1606.447933391272 | 0.07298135241769542 |  |  |  |  | 1.4 | 2 | 1056.177151695769 | 0.04798240597857739 | 19 | 50167.97807963593
1.4 | 2 | 1056.177151695769 | 0.0479824059785774 |  |  |  |  | 1.5 | 2 | 1937.65024666388 | 0.08802796067936315 | 24 | 50499.71837092048
1.5 | 2 | 1937.65024666388 | 0.08802796067936318 |  |  |  |  | 2 | 10 | 6438.61429414323 | 0.2925079419726379 | 101 | 246453.3694262468
2 | 10 | 6438.61429414323 | 0.292507941972638 |  |  |  |  | 2.1 | 2 | 1921.808291511875 | 0.08730825648733677 | 23 | 43794.88342668101
2.1 | 2 | 1921.808291511875 | 0.08730825648733678 |  |  |  |  | 2.2 | 2 | 785.1094175685358 | 0.03566772747440494 | 20 | 61513.7747455029
2.2 | 2 | 785.1094175685358 | 0.03566772747440494 |  |  |  |  | 2.3 | 2 | 484.0421625347272 | 0.02199016283982246 | 15 | 31979.82854321141
2.3 | 2 | 484.0421625347272 | 0.02199016283982246 |  |  |  |  | 2.4 | 2 | 1266.003901331241 | 0.05751489043917155 | 22 | 55039.02221812858
2.4 | 2 | 1266.003901331241 | 0.05751489043917157 |  |  |  |  | 2.5 | 2 | 1981.650521196851 | 0.09002690473190217 | 21 | 54125.8604927229
2.5 | 2 | 1981.650521196851 | 0.09002690473190218 |  |  |  |  | 3 | 10 | 8162.905731604065 | 0.3708429557956434 | 99 | 321510.64878525
3 | 10 | 8162.905731604065 | 0.3708429557956434 |  |  |  |  | 3.1 | 2 | 1244.015126545024 | 0.05651593461337115 | 22 | 70249.75091204779
3.1 | 2 | 1244.015126545024 | 0.05651593461337116 |  |  |  |  | 3.2 | 2 | 2091.360859838992 | 0.09501107429126295 | 19 | 40526.11900756777
3.2 | 2 | 2091.360859838992 | 0.09501107429126296 |  |  |  |  | 3.3 | 2 | 821.3265415224367 | 0.03731308094767634 | 20 | 70096.61938281677
3.3 | 2 | 821.3265415224367 | 0.03731308094767635 |  |  |  |  | 3.4 | 2 | 2418.551077894428 | 0.1098754120112645 | 23 | 75481.38210616942
3.4 | 2 | 2418.551077894428 | 0.1098754120112645 |  |  |  |  | 3.5 | 2 | 1587.652125803184 | 0.07212745393206842 | 15 | 65156.77737664829
3.5 | 2 | 1587.652125803184 | 0.07212745393206843
Grand Total | 30 | 22011.75889694481 | 1
Row Labels | Sum of Amount | Sum of Premium
1 | 111 | 323895.2068342012
1.1 | 27 | 72751.43670593218
1.2 | 21 | 74702.67475347099
1.3 | 20 | 75773.39892424161
1.4 | 19 | 50167.97807963593
1.5 | 24 | 50499.71837092048
2 | 101 | 246453.3694262468
2.1 | 23 | 43794.88342668101
2.2 | 20 | 61513.7747455029
2.3 | 15 | 31979.82854321141
2.4 | 22 | 55039.02221812858
2.5 | 21 | 54125.8604927229
3 | 99 | 321510.64878525
3.1 | 22 | 70249.75091204779
3.2 | 19 | 40526.11900756777
3.3 | 20 | 70096.61938281677
3.4 | 23 | 75481.38210616942
3.5 | 15 | 65156.77737664829
Grand Total | 311 | 891859.225045698