topic Re: Pivot Table Format- Add Manual rows in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-Format-Add-Manual-rows/m-p/714128#M473956 <HTML><HEAD></HEAD><BODY><P>The best way to do this for financial reports is to use a straight table not a pivot table.</P><P></P><P>Have a look at this thread for more details. <A _jive_internal="true" href="https://community.qlik.com/docs/DOC-3324">http://community.qlik.com/docs/DOC-3324</A></P><P><BR /> </P></BODY></HTML> Mon, 13 Oct 2014 13:30:06 GMT Colin-Albert 2014-10-13T13:30:06Z Pivot Table Format- Add Manual rows https://community.qlik.com/t5/QlikView/Pivot-Table-Format-Add-Manual-rows/m-p/714127#M473955 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have finance report i want to create manual row in the same reports example:</P><P>i have</P><P>Sales</P><P>Cost of sales</P><P>Gross Profit = Total , all these data from data source just i need to add one more row for</P><P>Gross Profit % Sales -</P><TABLE border="1" class="jiveBorder" height="149" style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; WIDTH: 401px; HEIGHT: 116px; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Group</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Value</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Group % Sales</STRONG></TH></TR><TR><TD style="padding: 2px;">Sales</TD><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">100 %100</TD></TR><TR><TD style="padding: 2px;">Cost Of Sales</TD><TD style="padding: 2px;">50</TD><TD style="padding: 2px;">50 %100</TD></TR><TR><TD style="padding: 2px;">Gross Profit(Sales+ CoS</TD><TD style="padding: 2px;">150</TD><TD style="padding: 2px;">150 % 100</TD></TR><TR><TD style="padding: 2px;">Gross Profit % Sales</TD><TD style="padding: 2px;">150/100</TD><TD style="padding: 2px;">(150/100) % 100</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>Please help me to create this format.</P></BODY></HTML> Mon, 13 Oct 2014 13:27:15 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Format-Add-Manual-rows/m-p/714127#M473955 2014-10-13T13:27:15Z Re: Pivot Table Format- Add Manual rows https://community.qlik.com/t5/QlikView/Pivot-Table-Format-Add-Manual-rows/m-p/714128#M473956 <HTML><HEAD></HEAD><BODY><P>The best way to do this for financial reports is to use a straight table not a pivot table.</P><P></P><P>Have a look at this thread for more details. <A _jive_internal="true" href="https://community.qlik.com/docs/DOC-3324">http://community.qlik.com/docs/DOC-3324</A></P><P><BR /> </P></BODY></HTML> Mon, 13 Oct 2014 13:30:06 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Format-Add-Manual-rows/m-p/714128#M473956 Colin-Albert 2014-10-13T13:30:06Z