topic Re: how to create report with pivot table. in QlikView https://community.qlik.com/t5/QlikView/how-to-create-report-with-pivot-table/m-p/960649#M946962 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hi Robert,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Thanks a lot, But as per excel I want to show&nbsp; =SUM(B3,D3,F3,H3) in J and =SUM(C3,E3,G3,I3) in K Column on right side of&nbsp; the sheet.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">And total&nbsp; of first,second,third and four should be below the row.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Region is the dimension and A &amp; B are the dimensions which i made by inline.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Plz guide me in detail so the i can create this table to get the exact output.</P></BODY></HTML> Sat, 19 Dec 2015 20:36:32 GMT lalitkgehlot89 2015-12-19T20:36:32Z how to create report with pivot table. https://community.qlik.com/t5/QlikView/how-to-create-report-with-pivot-table/m-p/960645#M946958 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am new in qlikview.</P><P>Plz help me out to create this report in qlikview.</P><P></P><P><IMG alt="PIVOT.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/109487_PIVOT.JPG" style="height: 95px; width: 620px;" /></P><P>Regards,</P><P>Lalit Kumar</P></BODY></HTML> Sat, 19 Dec 2015 18:26:03 GMT https://community.qlik.com/t5/QlikView/how-to-create-report-with-pivot-table/m-p/960645#M946958 lalitkgehlot89 2015-12-19T18:26:03Z Re: how to create report with pivot table. https://community.qlik.com/t5/QlikView/how-to-create-report-with-pivot-table/m-p/960646#M946959 <HTML><HEAD></HEAD><BODY><P>If all your dimension are as columns just move drag the Region to the top of the columns.</P><P>That should do the job.</P><P></P><P>Look her:</P><P></P><P><A href="https://community.qlik.com/thread/63309">Converting columns to rows and rows to columns ?</A></P></BODY></HTML> Sat, 19 Dec 2015 18:49:52 GMT https://community.qlik.com/t5/QlikView/how-to-create-report-with-pivot-table/m-p/960646#M946959 robert_mika 2015-12-19T18:49:52Z Re: how to create report with pivot table. https://community.qlik.com/t5/QlikView/how-to-create-report-with-pivot-table/m-p/960647#M946960 <HTML><HEAD></HEAD><BODY><P>see this documents</P></BODY></HTML> Sat, 19 Dec 2015 20:01:27 GMT https://community.qlik.com/t5/QlikView/how-to-create-report-with-pivot-table/m-p/960647#M946960 ecolomer 2015-12-19T20:01:27Z Re: how to create report with pivot table. https://community.qlik.com/t5/QlikView/how-to-create-report-with-pivot-table/m-p/960648#M946961 <HTML><HEAD></HEAD><BODY><P>Hi Robert,</P><P>Thanks a lot, But as per excel I want to show&nbsp; =SUM(B3,D3,F3,H3) in J and =SUM(C3,E3,G3,I3) in K Column on right side of&nbsp; the sheet.</P><P>And total&nbsp; of first,second,third and four should be below the row.</P><P>Region is the dimension and A &amp; B are the dimensions which i made by inline.</P><P>Plz guide me in detail so the i can create this table to get the exact output. </P><P></P><P>Regards,</P><P>Lalit kumar</P></BODY></HTML> Sat, 19 Dec 2015 20:15:01 GMT https://community.qlik.com/t5/QlikView/how-to-create-report-with-pivot-table/m-p/960648#M946961 lalitkgehlot89 2015-12-19T20:15:01Z Re: how to create report with pivot table. https://community.qlik.com/t5/QlikView/how-to-create-report-with-pivot-table/m-p/960649#M946962 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hi Robert,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Thanks a lot, But as per excel I want to show&nbsp; =SUM(B3,D3,F3,H3) in J and =SUM(C3,E3,G3,I3) in K Column on right side of&nbsp; the sheet.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">And total&nbsp; of first,second,third and four should be below the row.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Region is the dimension and A &amp; B are the dimensions which i made by inline.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Plz guide me in detail so the i can create this table to get the exact output.</P></BODY></HTML> Sat, 19 Dec 2015 20:36:32 GMT https://community.qlik.com/t5/QlikView/how-to-create-report-with-pivot-table/m-p/960649#M946962 lalitkgehlot89 2015-12-19T20:36:32Z