topic Pivot table Rankin in Qlik Answers https://community.qlik.com/t5/Qlik-Answers/Pivot-table-Rankin/m-p/2496677#M150 <P>Trying to get the Rank for a specific values in a dimension, which is aggregated by multiple dimensions in the rows and columns in a pivot table.</P> <P>&nbsp; Here is the example table and expected pivot table results</P> <TABLE dir="ltr" border="1" cellspacing="0" cellpadding="0" data-sheets-root="1" data-sheets-baot="1" data-sheets-original-selection="A2:G19" data-sheets-named-table-range="A2:G19" data-sheets-named-table="{&quot;1&quot;:{&quot;1&quot;:{&quot;1&quot;:{&quot;4&quot;:{&quot;1&quot;:2,&quot;2&quot;:3500116}},&quot;2&quot;:{&quot;4&quot;:{&quot;1&quot;:2,&quot;2&quot;:16777215}},&quot;3&quot;:1,&quot;4&quot;:{&quot;4&quot;:{&quot;1&quot;:2,&quot;2&quot;:16316922}},&quot;5&quot;:1}},&quot;2&quot;:&quot;Table1&quot;,&quot;3&quot;:[{&quot;1&quot;:0,&quot;2&quot;:1,&quot;3&quot;:{&quot;2&quot;:2},&quot;4&quot;:4},{&quot;1&quot;:4,&quot;2&quot;:1,&quot;3&quot;:{&quot;1&quot;:2,&quot;3&quot;:{&quot;2&quot;:14,&quot;3&quot;:2,&quot;4&quot;:{&quot;1&quot;:{&quot;1&quot;:{&quot;3&quot;:2},&quot;2&quot;:{&quot;1&quot;:{&quot;1&quot;:[{&quot;1&quot;:4,&quot;6&quot;:0},{&quot;1&quot;:2,&quot;3&quot;:&quot;ISNUMBER&quot;,&quot;4&quot;:1},{&quot;1&quot;:4,&quot;6&quot;:1},{&quot;1&quot;:2,&quot;3&quot;:&quot;ISDATE&quot;,&quot;4&quot;:1},{&quot;1&quot;:2,&quot;3&quot;:&quot;NOT&quot;,&quot;4&quot;:1},{&quot;1&quot;:2,&quot;3&quot;:&quot;AND&quot;,&quot;4&quot;:2},{&quot;1&quot;:1,&quot;2&quot;:&quot;=&quot;}]},&quot;3&quot;:&quot;R0]FISNUMBER:1]R1]FISDATE:1]FNOT:1]FAND:2]S&quot;},&quot;3&quot;:[{&quot;1&quot;:{&quot;1&quot;:0,&quot;2&quot;:1,&quot;3&quot;:0,&quot;4&quot;:1,&quot;5&quot;:1118464},&quot;2&quot;:0},{&quot;1&quot;:{&quot;1&quot;:0,&quot;2&quot;:1,&quot;3&quot;:0,&quot;4&quot;:1,&quot;5&quot;:1118464},&quot;2&quot;:1}]},&quot;5&quot;:&quot;Values in this column must be numbers.&quot;},&quot;5&quot;:{&quot;1&quot;:64,&quot;2&quot;:1,&quot;3&quot;:{&quot;1&quot;:2,&quot;3&quot;:1}}}},&quot;4&quot;:1},{&quot;1&quot;:5,&quot;2&quot;:1,&quot;3&quot;:{&quot;2&quot;:2},&quot;4&quot;:1},{&quot;1&quot;:6,&quot;2&quot;:1,&quot;3&quot;:{&quot;1&quot;:2,&quot;3&quot;:{&quot;2&quot;:14,&quot;3&quot;:2,&quot;4&quot;:{&quot;1&quot;:{&quot;1&quot;:{&quot;3&quot;:2},&quot;2&quot;:{&quot;1&quot;:{&quot;1&quot;:[{&quot;1&quot;:4,&quot;6&quot;:0},{&quot;1&quot;:2,&quot;3&quot;:&quot;ISNUMBER&quot;,&quot;4&quot;:1},{&quot;1&quot;:4,&quot;6&quot;:1},{&quot;1&quot;:2,&quot;3&quot;:&quot;ISDATE&quot;,&quot;4&quot;:1},{&quot;1&quot;:2,&quot;3&quot;:&quot;NOT&quot;,&quot;4&quot;:1},{&quot;1&quot;:2,&quot;3&quot;:&quot;AND&quot;,&quot;4&quot;:2},{&quot;1&quot;:1,&quot;2&quot;:&quot;=&quot;}]},&quot;3&quot;:&quot;R0]FISNUMBER:1]R1]FISDATE:1]FNOT:1]FAND:2]S&quot;},&quot;3&quot;:[{&quot;1&quot;:{&quot;1&quot;:0,&quot;2&quot;:1,&quot;3&quot;:0,&quot;4&quot;:1,&quot;5&quot;:1118464},&quot;2&quot;:0},{&quot;1&quot;:{&quot;1&quot;:0,&quot;2&quot;:1,&quot;3&quot;:0,&quot;4&quot;:1,&quot;5&quot;:1118464},&quot;2&quot;:1}]},&quot;5&quot;:&quot;Values in this column must be numbers.&quot;},&quot;5&quot;:{&quot;1&quot;:64,&quot;2&quot;:1,&quot;3&quot;:{&quot;1&quot;:2,&quot;3&quot;:1}}}},&quot;4&quot;:1}]}"><COLGROUP><COL width="100" /><COL width="100" /><COL width="100" /><COL width="100" /><COL width="100" /><COL width="111" /><COL width="100" /></COLGROUP> <TBODY> <TR> <TD>Region</TD> <TD>Product</TD> <TD>Source</TD> <TD>Industry</TD> <TD>FEE</TD> <TD>Bank Name</TD> <TD>Year</TD> </TR> <TR> <TD>India</TD> <TD>P1</TD> <TD>A</TD> <TD>L1</TD> <TD>80</TD> <TD>BOA</TD> <TD>2023</TD> </TR> <TR> <TD>India</TD> <TD>P1</TD> <TD>A</TD> <TD>L2</TD> <TD>88</TD> <TD>City</TD> <TD>2023</TD> </TR> <TR> <TD>India</TD> <TD>P2</TD> <TD>B</TD> <TD>L1</TD> <TD>23</TD> <TD>SriBank</TD> <TD>2023</TD> </TR> <TR> <TD>India</TD> <TD>P2</TD> <TD>B</TD> <TD>L2</TD> <TD>36</TD> <TD>HDFC</TD> <TD>2023</TD> </TR> <TR> <TD>USA</TD> <TD>P1</TD> <TD>A</TD> <TD>L1</TD> <TD>28</TD> <TD>BOA</TD> <TD>2023</TD> </TR> <TR> <TD>USA</TD> <TD>P1</TD> <TD>A</TD> <TD>L2</TD> <TD>51</TD> <TD>City</TD> <TD>2023</TD> </TR> <TR> <TD>USA</TD> <TD>P2</TD> <TD>B</TD> <TD>L1</TD> <TD>87</TD> <TD>SriBank</TD> <TD>2023</TD> </TR> <TR> <TD>USA</TD> <TD>P2</TD> <TD>B</TD> <TD>L2</TD> <TD>26</TD> <TD>HDFC</TD> <TD>2023</TD> </TR> <TR> <TD>India</TD> <TD>P1</TD> <TD>A</TD> <TD>L1</TD> <TD>20</TD> <TD>BOA</TD> <TD>2024</TD> </TR> <TR> <TD>India</TD> <TD>P1</TD> <TD>A</TD> <TD>L2</TD> <TD>23</TD> <TD>City</TD> <TD>2024</TD> </TR> <TR> <TD>India</TD> <TD>P1</TD> <TD>A</TD> <TD>L2</TD> <TD>43</TD> <TD>SriBank</TD> <TD>2024</TD> </TR> <TR> <TD>India</TD> <TD>P2</TD> <TD>B</TD> <TD>L2</TD> <TD>18</TD> <TD>HDFC</TD> <TD>2024</TD> </TR> <TR> <TD>India</TD> <TD>P2</TD> <TD>B</TD> <TD>L2</TD> <TD>68</TD> <TD>SriBank</TD> <TD>2024</TD> </TR> <TR> <TD>USA</TD> <TD>P1</TD> <TD>A</TD> <TD>L1</TD> <TD>30</TD> <TD>BOA</TD> <TD>2024</TD> </TR> <TR> <TD>USA</TD> <TD>P1</TD> <TD>A</TD> <TD>L2</TD> <TD>35</TD> <TD>City</TD> <TD>2024</TD> </TR> <TR> <TD>USA</TD> <TD>P2</TD> <TD>B</TD> <TD>L1</TD> <TD>44</TD> <TD>SriBank</TD> <TD>2024</TD> </TR> <TR> <TD>USA</TD> <TD>P2</TD> <TD>B</TD> <TD>L2</TD> <TD>95</TD> <TD>HDFC</TD> <TD>2024</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>In the Qlike Sense a Pivot table, dimension rows have Region, Source and Industry. Column has Year and Product Dimensions.<BR />Please help me to create a measure expression to get the Rank for the 'SriBank' in the BankName table when the 'SriBank' is compared with all other values in the BankName column, and comparing is based on the Sum of Fee. The Pivot table cell values would be the Rank of 'SriBank' by Rows and Column dimensions and Total aggregated by all the columns.&nbsp;<BR /><BR />Below is the expected pivot output</P> <TABLE dir="ltr" border="1" cellspacing="0" cellpadding="0" data-sheets-root="1" data-sheets-baot="1"><COLGROUP><COL width="100" /><COL width="100" /><COL width="100" /><COL width="100" /><COL width="100" /><COL width="111" /><COL width="100" /><COL width="100" /><COL width="100" /></COLGROUP> <TBODY> <TR> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>Year</TD> <TD>Product</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD colspan="3" rowspan="1">2023</TD> <TD colspan="3" rowspan="1">2024</TD> </TR> <TR> <TD>Region</TD> <TD>Source</TD> <TD>Industry</TD> <TD>2023 Total</TD> <TD>P1</TD> <TD>P2</TD> <TD>2024 Total</TD> <TD>P1</TD> <TD>P2</TD> </TR> <TR> <TD>Global</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>2</TD> <TD>0</TD> <TD>1</TD> <TD>1</TD> <TD>3</TD> <TD>2</TD> </TR> <TR> <TD colspan="1" rowspan="7"> <DIV>India</DIV> </TD> <TD>India Total</TD> <TD>&nbsp;</TD> <TD>4</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>1</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>A Total</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>0</TD> <TD>2</TD> <TD>1</TD> <TD>1</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>L1</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>L2</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>1</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>B Total</TD> <TD>&nbsp;</TD> <TD>2</TD> <TD>&nbsp;</TD> <TD>2</TD> <TD>1</TD> <TD>&nbsp;</TD> <TD>1</TD> </TR> <TR> <TD>B</TD> <TD>L1</TD> <TD>1</TD> <TD>&nbsp;</TD> <TD>1</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>L2</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>2</TD> </TR> <TR> <TD colspan="1" rowspan="7"> <DIV>USA</DIV> </TD> <TD>USA Total</TD> <TD>&nbsp;</TD> <TD>1</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>2</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>A Total</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>A</TD> <TD>L1</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>L2</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>B Total</TD> <TD>&nbsp;</TD> <TD>1</TD> <TD>&nbsp;</TD> <TD>1</TD> <TD>2</TD> <TD>2</TD> <TD>2</TD> </TR> <TR> <TD>B</TD> <TD>L1</TD> <TD>1</TD> <TD>&nbsp;</TD> <TD>1</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>1</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>L2</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> </TBODY> </TABLE> Sat, 07 Dec 2024 20:23:09 GMT Bettegowda 2024-12-07T20:23:09Z Pivot table Rankin https://community.qlik.com/t5/Qlik-Answers/Pivot-table-Rankin/m-p/2496677#M150 <P>Trying to get the Rank for a specific values in a dimension, which is aggregated by multiple dimensions in the rows and columns in a pivot table.</P> <P>&nbsp; Here is the example table and expected pivot table results</P> <TABLE dir="ltr" border="1" cellspacing="0" cellpadding="0" data-sheets-root="1" data-sheets-baot="1" data-sheets-original-selection="A2:G19" data-sheets-named-table-range="A2:G19" data-sheets-named-table="{&quot;1&quot;:{&quot;1&quot;:{&quot;1&quot;:{&quot;4&quot;:{&quot;1&quot;:2,&quot;2&quot;:3500116}},&quot;2&quot;:{&quot;4&quot;:{&quot;1&quot;:2,&quot;2&quot;:16777215}},&quot;3&quot;:1,&quot;4&quot;:{&quot;4&quot;:{&quot;1&quot;:2,&quot;2&quot;:16316922}},&quot;5&quot;:1}},&quot;2&quot;:&quot;Table1&quot;,&quot;3&quot;:[{&quot;1&quot;:0,&quot;2&quot;:1,&quot;3&quot;:{&quot;2&quot;:2},&quot;4&quot;:4},{&quot;1&quot;:4,&quot;2&quot;:1,&quot;3&quot;:{&quot;1&quot;:2,&quot;3&quot;:{&quot;2&quot;:14,&quot;3&quot;:2,&quot;4&quot;:{&quot;1&quot;:{&quot;1&quot;:{&quot;3&quot;:2},&quot;2&quot;:{&quot;1&quot;:{&quot;1&quot;:[{&quot;1&quot;:4,&quot;6&quot;:0},{&quot;1&quot;:2,&quot;3&quot;:&quot;ISNUMBER&quot;,&quot;4&quot;:1},{&quot;1&quot;:4,&quot;6&quot;:1},{&quot;1&quot;:2,&quot;3&quot;:&quot;ISDATE&quot;,&quot;4&quot;:1},{&quot;1&quot;:2,&quot;3&quot;:&quot;NOT&quot;,&quot;4&quot;:1},{&quot;1&quot;:2,&quot;3&quot;:&quot;AND&quot;,&quot;4&quot;:2},{&quot;1&quot;:1,&quot;2&quot;:&quot;=&quot;}]},&quot;3&quot;:&quot;R0]FISNUMBER:1]R1]FISDATE:1]FNOT:1]FAND:2]S&quot;},&quot;3&quot;:[{&quot;1&quot;:{&quot;1&quot;:0,&quot;2&quot;:1,&quot;3&quot;:0,&quot;4&quot;:1,&quot;5&quot;:1118464},&quot;2&quot;:0},{&quot;1&quot;:{&quot;1&quot;:0,&quot;2&quot;:1,&quot;3&quot;:0,&quot;4&quot;:1,&quot;5&quot;:1118464},&quot;2&quot;:1}]},&quot;5&quot;:&quot;Values in this column must be numbers.&quot;},&quot;5&quot;:{&quot;1&quot;:64,&quot;2&quot;:1,&quot;3&quot;:{&quot;1&quot;:2,&quot;3&quot;:1}}}},&quot;4&quot;:1},{&quot;1&quot;:5,&quot;2&quot;:1,&quot;3&quot;:{&quot;2&quot;:2},&quot;4&quot;:1},{&quot;1&quot;:6,&quot;2&quot;:1,&quot;3&quot;:{&quot;1&quot;:2,&quot;3&quot;:{&quot;2&quot;:14,&quot;3&quot;:2,&quot;4&quot;:{&quot;1&quot;:{&quot;1&quot;:{&quot;3&quot;:2},&quot;2&quot;:{&quot;1&quot;:{&quot;1&quot;:[{&quot;1&quot;:4,&quot;6&quot;:0},{&quot;1&quot;:2,&quot;3&quot;:&quot;ISNUMBER&quot;,&quot;4&quot;:1},{&quot;1&quot;:4,&quot;6&quot;:1},{&quot;1&quot;:2,&quot;3&quot;:&quot;ISDATE&quot;,&quot;4&quot;:1},{&quot;1&quot;:2,&quot;3&quot;:&quot;NOT&quot;,&quot;4&quot;:1},{&quot;1&quot;:2,&quot;3&quot;:&quot;AND&quot;,&quot;4&quot;:2},{&quot;1&quot;:1,&quot;2&quot;:&quot;=&quot;}]},&quot;3&quot;:&quot;R0]FISNUMBER:1]R1]FISDATE:1]FNOT:1]FAND:2]S&quot;},&quot;3&quot;:[{&quot;1&quot;:{&quot;1&quot;:0,&quot;2&quot;:1,&quot;3&quot;:0,&quot;4&quot;:1,&quot;5&quot;:1118464},&quot;2&quot;:0},{&quot;1&quot;:{&quot;1&quot;:0,&quot;2&quot;:1,&quot;3&quot;:0,&quot;4&quot;:1,&quot;5&quot;:1118464},&quot;2&quot;:1}]},&quot;5&quot;:&quot;Values in this column must be numbers.&quot;},&quot;5&quot;:{&quot;1&quot;:64,&quot;2&quot;:1,&quot;3&quot;:{&quot;1&quot;:2,&quot;3&quot;:1}}}},&quot;4&quot;:1}]}"><COLGROUP><COL width="100" /><COL width="100" /><COL width="100" /><COL width="100" /><COL width="100" /><COL width="111" /><COL width="100" /></COLGROUP> <TBODY> <TR> <TD>Region</TD> <TD>Product</TD> <TD>Source</TD> <TD>Industry</TD> <TD>FEE</TD> <TD>Bank Name</TD> <TD>Year</TD> </TR> <TR> <TD>India</TD> <TD>P1</TD> <TD>A</TD> <TD>L1</TD> <TD>80</TD> <TD>BOA</TD> <TD>2023</TD> </TR> <TR> <TD>India</TD> <TD>P1</TD> <TD>A</TD> <TD>L2</TD> <TD>88</TD> <TD>City</TD> <TD>2023</TD> </TR> <TR> <TD>India</TD> <TD>P2</TD> <TD>B</TD> <TD>L1</TD> <TD>23</TD> <TD>SriBank</TD> <TD>2023</TD> </TR> <TR> <TD>India</TD> <TD>P2</TD> <TD>B</TD> <TD>L2</TD> <TD>36</TD> <TD>HDFC</TD> <TD>2023</TD> </TR> <TR> <TD>USA</TD> <TD>P1</TD> <TD>A</TD> <TD>L1</TD> <TD>28</TD> <TD>BOA</TD> <TD>2023</TD> </TR> <TR> <TD>USA</TD> <TD>P1</TD> <TD>A</TD> <TD>L2</TD> <TD>51</TD> <TD>City</TD> <TD>2023</TD> </TR> <TR> <TD>USA</TD> <TD>P2</TD> <TD>B</TD> <TD>L1</TD> <TD>87</TD> <TD>SriBank</TD> <TD>2023</TD> </TR> <TR> <TD>USA</TD> <TD>P2</TD> <TD>B</TD> <TD>L2</TD> <TD>26</TD> <TD>HDFC</TD> <TD>2023</TD> </TR> <TR> <TD>India</TD> <TD>P1</TD> <TD>A</TD> <TD>L1</TD> <TD>20</TD> <TD>BOA</TD> <TD>2024</TD> </TR> <TR> <TD>India</TD> <TD>P1</TD> <TD>A</TD> <TD>L2</TD> <TD>23</TD> <TD>City</TD> <TD>2024</TD> </TR> <TR> <TD>India</TD> <TD>P1</TD> <TD>A</TD> <TD>L2</TD> <TD>43</TD> <TD>SriBank</TD> <TD>2024</TD> </TR> <TR> <TD>India</TD> <TD>P2</TD> <TD>B</TD> <TD>L2</TD> <TD>18</TD> <TD>HDFC</TD> <TD>2024</TD> </TR> <TR> <TD>India</TD> <TD>P2</TD> <TD>B</TD> <TD>L2</TD> <TD>68</TD> <TD>SriBank</TD> <TD>2024</TD> </TR> <TR> <TD>USA</TD> <TD>P1</TD> <TD>A</TD> <TD>L1</TD> <TD>30</TD> <TD>BOA</TD> <TD>2024</TD> </TR> <TR> <TD>USA</TD> <TD>P1</TD> <TD>A</TD> <TD>L2</TD> <TD>35</TD> <TD>City</TD> <TD>2024</TD> </TR> <TR> <TD>USA</TD> <TD>P2</TD> <TD>B</TD> <TD>L1</TD> <TD>44</TD> <TD>SriBank</TD> <TD>2024</TD> </TR> <TR> <TD>USA</TD> <TD>P2</TD> <TD>B</TD> <TD>L2</TD> <TD>95</TD> <TD>HDFC</TD> <TD>2024</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>In the Qlike Sense a Pivot table, dimension rows have Region, Source and Industry. Column has Year and Product Dimensions.<BR />Please help me to create a measure expression to get the Rank for the 'SriBank' in the BankName table when the 'SriBank' is compared with all other values in the BankName column, and comparing is based on the Sum of Fee. The Pivot table cell values would be the Rank of 'SriBank' by Rows and Column dimensions and Total aggregated by all the columns.&nbsp;<BR /><BR />Below is the expected pivot output</P> <TABLE dir="ltr" border="1" cellspacing="0" cellpadding="0" data-sheets-root="1" data-sheets-baot="1"><COLGROUP><COL width="100" /><COL width="100" /><COL width="100" /><COL width="100" /><COL width="100" /><COL width="111" /><COL width="100" /><COL width="100" /><COL width="100" /></COLGROUP> <TBODY> <TR> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>Year</TD> <TD>Product</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD colspan="3" rowspan="1">2023</TD> <TD colspan="3" rowspan="1">2024</TD> </TR> <TR> <TD>Region</TD> <TD>Source</TD> <TD>Industry</TD> <TD>2023 Total</TD> <TD>P1</TD> <TD>P2</TD> <TD>2024 Total</TD> <TD>P1</TD> <TD>P2</TD> </TR> <TR> <TD>Global</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>2</TD> <TD>0</TD> <TD>1</TD> <TD>1</TD> <TD>3</TD> <TD>2</TD> </TR> <TR> <TD colspan="1" rowspan="7"> <DIV>India</DIV> </TD> <TD>India Total</TD> <TD>&nbsp;</TD> <TD>4</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>1</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>A Total</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>0</TD> <TD>2</TD> <TD>1</TD> <TD>1</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>L1</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>L2</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>1</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>B Total</TD> <TD>&nbsp;</TD> <TD>2</TD> <TD>&nbsp;</TD> <TD>2</TD> <TD>1</TD> <TD>&nbsp;</TD> <TD>1</TD> </TR> <TR> <TD>B</TD> <TD>L1</TD> <TD>1</TD> <TD>&nbsp;</TD> <TD>1</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>L2</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>2</TD> </TR> <TR> <TD colspan="1" rowspan="7"> <DIV>USA</DIV> </TD> <TD>USA Total</TD> <TD>&nbsp;</TD> <TD>1</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>2</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>A Total</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>A</TD> <TD>L1</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>L2</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>B Total</TD> <TD>&nbsp;</TD> <TD>1</TD> <TD>&nbsp;</TD> <TD>1</TD> <TD>2</TD> <TD>2</TD> <TD>2</TD> </TR> <TR> <TD>B</TD> <TD>L1</TD> <TD>1</TD> <TD>&nbsp;</TD> <TD>1</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>1</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>L2</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> </TBODY> </TABLE> Sat, 07 Dec 2024 20:23:09 GMT https://community.qlik.com/t5/Qlik-Answers/Pivot-table-Rankin/m-p/2496677#M150 Bettegowda 2024-12-07T20:23:09Z