topic How to add two rows in a pivot table? in QlikView https://community.qlik.com/t5/QlikView/How-to-add-two-rows-in-a-pivot-table/m-p/1024862#M925220 <HTML><HEAD></HEAD><BODY><P>Hi I have attached a sample snapshot where&nbsp; I have to add the two rows values of hierarchy level 00 and 01 and 05&nbsp; and 06. How to do so?</P><P>so that I will be sorting my data like</P><P></P><P>00-01</P><P>02</P><P>03</P><P>04</P><P>05-06 </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT nishanthi_8 2020-11-25T16:16:04Z How to add two rows in a pivot table? https://community.qlik.com/t5/QlikView/How-to-add-two-rows-in-a-pivot-table/m-p/1024862#M925220 <HTML><HEAD></HEAD><BODY><P>Hi I have attached a sample snapshot where&nbsp; I have to add the two rows values of hierarchy level 00 and 01 and 05&nbsp; and 06. How to do so?</P><P>so that I will be sorting my data like</P><P></P><P>00-01</P><P>02</P><P>03</P><P>04</P><P>05-06 </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-add-two-rows-in-a-pivot-table/m-p/1024862#M925220 nishanthi_8 2020-11-25T16:16:04Z Re: How to add two rows in a pivot table? https://community.qlik.com/t5/QlikView/How-to-add-two-rows-in-a-pivot-table/m-p/1024863#M925221 <HTML><HEAD></HEAD><BODY><P>chk dis</P><P><A href="https://community.qlik.com/message/728445">Add Rows on Pivot Tables</A></P><P><A href="https://community.qlik.com/message/214358">very very important....how to add a row in pivot table</A></P></BODY></HTML> Thu, 31 Mar 2016 11:23:34 GMT https://community.qlik.com/t5/QlikView/How-to-add-two-rows-in-a-pivot-table/m-p/1024863#M925221 Chanty4u 2016-03-31T11:23:34Z Re: How to add two rows in a pivot table? https://community.qlik.com/t5/QlikView/How-to-add-two-rows-in-a-pivot-table/m-p/1024864#M925222 <HTML><HEAD></HEAD><BODY><P>Use a calculated dimension;</P><P></P><P><STRONG>If(Match(HierarchyLevel, '00', '01', Dual('00-01', 0),</STRONG></P><P><STRONG>If(Match(</STRONG><SPAN style="font-size: 13.3333px;"><STRONG>HierarchyLevel, '05', '06', Dual('05-06', 1000), </STRONG><SPAN style="font-size: 13.3333px;"><STRONG>HierarchyLevel))</STRONG></SPAN></SPAN></P></BODY></HTML> Thu, 31 Mar 2016 11:25:28 GMT https://community.qlik.com/t5/QlikView/How-to-add-two-rows-in-a-pivot-table/m-p/1024864#M925222 sunny_talwar 2016-03-31T11:25:28Z