Spreadsheet: 851355d1701565499-power-query-how-to-sort-values-in-matrix-visual-according-to-another-column-powerbi-company-b
Sheet: sht_DataEntry

No. | Company Name | Financial Statement Title | Financial Statement Main Items | Financial Statement Details | 2016 Balance | 2017 Balance | 2018 Balance | 2019 Balance | 2020 Balance | 2021 Balance |  | No. | Company Name | 2016 Vertical | 2017 Vertical | 2018 Vertical | 2019 Vertical | 2020 Vertical | 2021 Vertical |  | No. | Company Name | 2017 Horizontal | 2018 Horizontal | 2019 Horizontal | 2020 Horizontal | 2021 Horizontal
1 | Company B | (1) Balance Sheet | [1-1] Non Current Assets | Non Current Assets Details #1 | 62840889 | 964982047 | 539892547 | 115704501 | 563968464 | 484629578 |  | 1 | Company B |  |  |  |  |  |  |  | 1 | Company B
2 | Company B | (1) Balance Sheet | [1-1] Non Current Assets | Non Current Assets Details #2 |  | 497254237 | 689359684 | 461519922 | 856054665 | 63119372 |  | 2 | Company B |  |  |  |  |  |  |  | 2 | Company B
3 | Company B | (1) Balance Sheet | [1-1] Non Current Assets | Non Current Assets Details #3 | 605577477 | 800167907 | 698940716 |  |  |  |  | 3 | Company B |  |  |  |  |  |  |  | 3 | Company B
4 | Company B | (1) Balance Sheet | [1-6] Balance Sheet Totals | Total Non Current Assets |  |  |  |  |  |  |  | 4 | Company B |  |  |  |  |  |  |  | 4 | Company B
5 | Company B | (1) Balance Sheet | [1-2] Current Assets | Current Assets Details #1 | 690951396 | 644813721 | 838382512 | 549808018 | 956655957 | 433410826 |  | 5 | Company B |  |  |  |  |  |  |  | 5 | Company B
6 | Company B | (1) Balance Sheet | [1-2] Current Assets | Current Assets Details #2 | 73401823 | 418722431 | 81314606 | 592594096 | 458989034 | 358700432 |  | 6 | Company B |  |  |  |  |  |  |  | 6 | Company B
7 | Company B | (1) Balance Sheet | [1-2] Current Assets | Current Assets Details #3 | 751143006 | 415023995 | 416115261 | 78301251 | 980062569 | 17974422 |  | 7 | Company B |  |  |  |  |  |  |  | 7 | Company B
8 | Company B | (1) Balance Sheet | [1-6] Balance Sheet Totals | Total Current Assets |  |  |  |  |  |  |  | 8 | Company B |  |  |  |  |  |  |  | 8 | Company B
9 | Company B | (1) Balance Sheet | [1-6] Balance Sheet Totals | Total Assets |  |  |  |  |  |  |  | 9 | Company B |  |  |  |  |  |  |  | 9 | Company B
10 | Company B | (1) Balance Sheet | [1-3] Non Current Liabilities | Non Current Liabilities Details #1 | 76666046 | 18209706 | 432638381 | 168319546 | 661982518 | 886482151 |  | 10 | Company B |  |  |  |  |  |  |  | 10 | Company B
11 | Company B | (1) Balance Sheet | [1-3] Non Current Liabilities | Non Current Liabilities Details #2 | 919651041 | 307545921 | 521206875 | 466272281 | 441681065 | 77105808 |  | 11 | Company B |  |  |  |  |  |  |  | 11 | Company B
12 | Company B | (1) Balance Sheet | [1-3] Non Current Liabilities | Non Current Liabilities Details #3 | 118287044 | 258572618 | 179726876 | 180924059 | 346202808 | 812393242 |  | 12 | Company B |  |  |  |  |  |  |  | 12 | Company B
13 | Company B | (1) Balance Sheet | [1-6] Balance Sheet Totals | Total Non Current Liabilities |  |  |  |  |  |  |  | 13 | Company B |  |  |  |  |  |  |  | 13 | Company B
14 | Company B | (1) Balance Sheet | [1-4] Current Liabilities | Current Liabilities Details #1 | 215850018 | 231457941 | 673354238 | 908763722 | 915066479 | 381076199 |  | 14 | Company B |  |  |  |  |  |  |  | 14 | Company B
15 | Company B | (1) Balance Sheet | [1-4] Current Liabilities | Current Liabilities Details #2 | 500365 | 482635446 | 36023195 | 927627278 | 98557186 | 708872323 |  | 15 | Company B |  |  |  |  |  |  |  | 15 | Company B
16 | Company B | (1) Balance Sheet | [1-4] Current Liabilities | Current Liabilities Details #3 | 226304 | 3865009 | 892101857 | 114847042 | 848407652 | 1570249 |  | 16 | Company B |  |  |  |  |  |  |  | 16 | Company B
17 | Company B | (1) Balance Sheet | [1-6] Balance Sheet Totals | Total Current Liabilities |  |  |  |  |  |  |  | 17 | Company B |  |  |  |  |  |  |  | 17 | Company B
18 | Company B | (1) Balance Sheet | [1-6] Balance Sheet Totals | Total Liabilities |  |  |  |  |  |  |  | 18 | Company B |  |  |  |  |  |  |  | 18 | Company B
19 | Company B | (1) Balance Sheet | [1-5] Owners Equity | Owners Equity Details #1 |  |  |  | 0 | 0 | 0 |  | 19 | Company B |  |  |  |  |  |  |  | 19 | Company B
20 | Company B | (1) Balance Sheet | [1-5] Owners Equity | Owners Equity Details #2 | 0 |  |  | 0 |  | 0 |  | 20 | Company B |  |  |  |  |  |  |  | 20 | Company B
21 | Company B | (1) Balance Sheet | [1-5] Owners Equity | Owners Equity Details #3 |  |  |  | 0 | 0 | 0 |  | 21 | Company B |  |  |  |  |  |  |  | 21 | Company B
22 | Company B | (1) Balance Sheet | [1-6] Balance Sheet Totals | Total Owners Equity |  |  |  |  |  |  |  | 22 | Company B |  |  |  |  |  |  |  | 22 | Company B
23 | Company B | (1) Balance Sheet | [1-6] Balance Sheet Totals | Total Liabilities & Owners Equity |  |  |  |  |  |  |  | 23 | Company B |  |  |  |  |  |  |  | 23 | Company B
No. | Company Name | Financial Statement Title | Financial Statement Main Items | Financial Statement Details | 2016 Balance | 2017 Balance | 2018 Balance | 2019 Balance | 2020 Balance | 2021 Balance |  | No. | Company Name | 2016 Vertical | 2017 Vertical | 2018 Vertical | 2019 Vertical | 2020 Vertical | 2021 Vertical |  | No. | Company Name | 2017 Horizontal | 2018 Horizontal | 2019 Horizontal | 2020 Horizontal | 2021 Horizontal
1 | Company B | (2) Income Statement | [2-1] Income | Income Statements Details #1 | 709705054 | 435002857 | 381943403 | 663239266 | 136639253 | 33847234 |  | 1 | Company B |  |  |  |  |  |  |  | 1 | Company B
2 | Company B | (2) Income Statement | [2-1] Income | Income Statements Details #2 | 717216836 | 170979439 | 265911023 | 611695495 | 299537129 | 60876541 |  | 2 | Company B |  |  |  |  |  |  |  | 2 | Company B
3 | Company B | (2) Income Statement | [2-1] Income | Income Statements Details #3 | 422366776 | 336169099 | 339635383 | -795575488 | 648677389 | 723321147 |  | 3 | Company B |  |  |  |  |  |  |  | 3 | Company B
4 | Company B | (2) Income Statement | [2-1] Income | Income Statements Details #4 | 83911746 | 966116307 | 874587706 | 560022693 | 129956587 | 569747676 |  | 4 | Company B |  |  |  |  |  |  |  | 4 | Company B
5 | Company B | (2) Income Statement | [2-2] Income Totals | Total #1 |  |  |  |  |  |  |  | 5 | Company B |  |  |  |  |  |  |  | 5 | Company B
6 | Company B | (2) Income Statement | [2-1] Income | Income Statements Details #6 | 760792031 | 557020351 | 859001462 | 172568096 | 568959091 | 294579022 |  | 6 | Company B |  |  |  |  |  |  |  | 6 | Company B
7 | Company B | (2) Income Statement | [2-1] Income | Income Statements Details #7 | -113537707 | 971820299 | 958378941 | 828349888 | 3103815 | 45782917 |  | 7 | Company B |  |  |  |  |  |  |  | 7 | Company B
8 | Company B | (2) Income Statement | [2-1] Income | Income Statements Details #8 | 881927104 | 723747633 | 24152708 | 418225924 | 179715022 | 477169826 |  | 8 | Company B |  |  |  |  |  |  |  | 8 | Company B
9 | Company B | (2) Income Statement | [2-1] Income | Income Statements Details #9 | 542163592 | 884124214 | 177994637 | 648880776 | 163710529 | 722022716 |  | 9 | Company B |  |  |  |  |  |  |  | 9 | Company B
10 | Company B | (2) Income Statement | [2-2] Income Totals | Total #2 |  |  |  |  |  |  |  | 10 | Company B |  |  |  |  |  |  |  | 10 | Company B
No. | Company Name | Financial Statement Title | Financial Statement Main Items | Financial Statement Details | 2016 Balance | 2017 Balance | 2018 Balance | 2019 Balance | 2020 Balance | 2021 Balance |  | No. | Company Name | 2016 Vertical | 2017 Vertical | 2018 Vertical | 2019 Vertical | 2020 Vertical | 2021 Vertical |  | No. | Company Name | 2017 Horizontal | 2018 Horizontal | 2019 Horizontal | 2020 Horizontal | 2021 Horizontal
1 | Company B | (3) Cash Flow Statement | [3-1] Cash Flow | Cash Flow Details #1 | 924269447 | 191185033 | 290843718 | 593485778 | 409043859 | 215361279 |  | 1 | Company B |  |  |  |  |  |  |  | 1 | Company B
2 | Company B | (3) Cash Flow Statement | [3-1] Cash Flow | Cash Flow Details #2 | 410835941 | 342804481 | 38537857 | 489375473 | 111718454 | 97504466 |  | 2 | Company B |  |  |  |  |  |  |  | 2 | Company B
3 | Company B | (3) Cash Flow Statement | [3-1] Cash Flow | Cash Flow Details #3 | 248348757 | 821215054 | 807466809 | 59391191 | 833683807 | 346569093 |  | 3 | Company B |  |  |  |  |  |  |  | 3 | Company B
4 | Company B | (3) Cash Flow Statement | [3-2] Cash Flow Totals | Total #1 |  |  |  |  |  |  |  | 4 | Company B |  |  |  |  |  |  |  | 4 | Company B
5 | Company B | (3) Cash Flow Statement | [3-1] Cash Flow | Cash Flow Details #4 | 729211385 | 370050036 | 475052578 | 369717438 | 880733815 | 346702538 |  | 5 | Company B |  |  |  |  |  |  |  | 5 | Company B
6 | Company B | (3) Cash Flow Statement | [3-1] Cash Flow | Cash Flow Details #5 | 423766476 | 827255074 | 882569436 | 421560586 | 914833053 | 14295441 |  | 6 | Company B |  |  |  |  |  |  |  | 6 | Company B
7 | Company B | (3) Cash Flow Statement | [3-1] Cash Flow | Cash Flow Details #6 | 617370521 | 940593647 | 198258692 | 378352464 | 844200264 | 248347485 |  | 7 | Company B |  |  |  |  |  |  |  | 7 | Company B
8 | Company B | (3) Cash Flow Statement | [3-2] Cash Flow Totals | Total #2 |  |  |  |  |  |  |  | 8 | Company B |  |  |  |  |  |  |  | 8 | Company B
9 | Company B | (3) Cash Flow Statement | [3-1] Cash Flow | Cash Flow Details #7 | 621120284 | 197181894 | 404968154 | 938461439 | 66688858 | 24616375 |  | 9 | Company B |  |  |  |  |  |  |  | 9 | Company B
10 | Company B | (3) Cash Flow Statement | [3-1] Cash Flow | Cash Flow Details #8 | 774498369 | 552089201 | 549752534 | 963829093 | 570292933 | 303470832 |  | 10 | Company B |  |  |  |  |  |  |  | 10 | Company B
11 | Company B | (3) Cash Flow Statement | [3-1] Cash Flow | Cash Flow Details #9 | 560061212 | 61449412 | 349886594 | 759283115 | 160138017 | 93642002 |  | 11 | Company B |  |  |  |  |  |  |  | 11 | Company B
12 | Company B | (3) Cash Flow Statement | [3-2] Cash Flow Totals | Total #3 |  |  |  |  |  |  |  | 12 | Company B |  |  |  |  |  |  |  | 12 | Company B
13 | Company B | (3) Cash Flow Statement | [3-2] Cash Flow Totals | Total #4 |  |  |  |  |  |  |  | 13 | Company B |  |  |  |  |  |  |  | 13 | Company B
No. | Company Name | Ratio | Ratio Type (Amount) | [NAME] | 2016 Ratios (Amount) | 2017 Ratios (Amount) | 2018 Ratios (Amount) | 2019 Ratios (Amount) | 2020 Ratios (Amount) | 2021 Ratios (Amount)
1 | Company B | (4) Ratios | [4-1] General [NAME] (Amount) | Amount Name #1
2 | Company B | (4) Ratios | [4-1] General [NAME] (Amount) | Amount Name #2
3 | Company B | (4) Ratios | [4-1] General [NAME] (Amount) | Amount Name #3
No. | Company Name | Ratio | Ratio Type (Times) | [NAME] | 2016 Ratios (Times) | 2017 Ratios (Times) | 2018 Ratios (Times) | 2019 Ratios (Times) | 2020 Ratios (Times) | 2021 Ratios (Times)
1 | Company B | (4) Ratios | [4-2] Activities Ratios (Times) | Times Name #1
2 | Company B | (4) Ratios | [4-2] Activities Ratios (Times) | Times Name #2
3 | Company B | (4) Ratios | [4-2] Activities Ratios (Times) | Times Name #3
No. | Company Name | Ratio | Ratio Type (Percentage) | [NAME] | 2016 Ratios (Percentage) | 2017 Ratios (Percentage) | 2018 Ratios (Percentage) | 2019 Ratios (Percentage) | 2020 Ratios (Percentage) | 2021 Ratios (Percentage)
1 | Company B | (4) Ratios | [4-3] Profitability Ratios (Percentage) | Percentage #1
2 | Company B | (4) Ratios | [4-3] Profitability Ratios (Percentage) | Percentage #2
3 | Company B | (4) Ratios | [4-3] Profitability Ratios (Percentage) | Percentage #3