topic Grouping the data in Pivot? in QlikView https://community.qlik.com/t5/QlikView/Grouping-the-data-in-Pivot/m-p/99611#M15901 <HTML><HEAD></HEAD><BODY><P>Hi Folks,</P><P></P><P>I have a scenario below. I want to show the data in pivot if we collapse to Type level Its default showing 30147 as per pivot functionality but I need to show data like 3rd table below ( In Pivot I Need).</P><P>I need to sum where scale is millions but I don't want to sum for Count and %. I need to show all the data which is like 3rd table.</P><P></P><P>Can you please help me on this?</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/209704_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Thu, 02 Aug 2018 12:48:48 GMT skumarqv11 2018-08-02T12:48:48Z Grouping the data in Pivot? https://community.qlik.com/t5/QlikView/Grouping-the-data-in-Pivot/m-p/99611#M15901 <HTML><HEAD></HEAD><BODY><P>Hi Folks,</P><P></P><P>I have a scenario below. I want to show the data in pivot if we collapse to Type level Its default showing 30147 as per pivot functionality but I need to show data like 3rd table below ( In Pivot I Need).</P><P>I need to sum where scale is millions but I don't want to sum for Count and %. I need to show all the data which is like 3rd table.</P><P></P><P>Can you please help me on this?</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/209704_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Thu, 02 Aug 2018 12:48:48 GMT https://community.qlik.com/t5/QlikView/Grouping-the-data-in-Pivot/m-p/99611#M15901 skumarqv11 2018-08-02T12:48:48Z