topic Create income statement table with common size in QlikView https://community.qlik.com/t5/QlikView/Create-income-statement-table-with-common-size/m-p/1434327#M818653 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want to create a income statement table with common size%, and&nbsp; my raw data format is as below.</P><P>Can I create an income statement table with common size% as below table2?</P><P></P><P>Thanks a lot!</P><P></P><P>&lt;Table1&gt; Raw data format</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Item</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Revenues</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Costs</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Expense</STRONG></TH></TR><TR><TD style="padding: 2px;"><P>A</P></TD><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;">10</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">110</TD><TD style="padding: 2px;">22</TD><TD style="padding: 2px;">8</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">90</TD><TD style="padding: 2px;">25</TD><TD style="padding: 2px;">9</TD></TR></TBODY></TABLE><P></P><P>&lt;Table2&gt; Income statement table with common size%</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Item</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Total Number</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>%</STRONG></TH></TR><TR><TD style="padding: 2px;">Revenues</TD><TD style="padding: 2px;">300</TD><TD style="padding: 2px;">100%</TD></TR><TR><TD style="padding: 2px;">Costs</TD><TD style="padding: 2px;">67</TD><TD style="padding: 2px;">22.3%</TD></TR><TR><TD style="padding: 2px;">Gross</TD><TD style="padding: 2px;">233</TD><TD style="padding: 2px;">77.7%</TD></TR><TR><TD style="padding: 2px;">Expense</TD><TD style="padding: 2px;">27</TD><TD style="padding: 2px;">9%</TD></TR><TR><TD style="padding: 2px;">Profit</TD><TD style="padding: 2px;">206</TD><TD style="padding: 2px;">68.7%</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT katetsan 2020-11-25T16:16:04Z Create income statement table with common size https://community.qlik.com/t5/QlikView/Create-income-statement-table-with-common-size/m-p/1434327#M818653 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want to create a income statement table with common size%, and&nbsp; my raw data format is as below.</P><P>Can I create an income statement table with common size% as below table2?</P><P></P><P>Thanks a lot!</P><P></P><P>&lt;Table1&gt; Raw data format</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Item</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Revenues</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Costs</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Expense</STRONG></TH></TR><TR><TD style="padding: 2px;"><P>A</P></TD><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;">10</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">110</TD><TD style="padding: 2px;">22</TD><TD style="padding: 2px;">8</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">90</TD><TD style="padding: 2px;">25</TD><TD style="padding: 2px;">9</TD></TR></TBODY></TABLE><P></P><P>&lt;Table2&gt; Income statement table with common size%</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Item</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Total Number</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>%</STRONG></TH></TR><TR><TD style="padding: 2px;">Revenues</TD><TD style="padding: 2px;">300</TD><TD style="padding: 2px;">100%</TD></TR><TR><TD style="padding: 2px;">Costs</TD><TD style="padding: 2px;">67</TD><TD style="padding: 2px;">22.3%</TD></TR><TR><TD style="padding: 2px;">Gross</TD><TD style="padding: 2px;">233</TD><TD style="padding: 2px;">77.7%</TD></TR><TR><TD style="padding: 2px;">Expense</TD><TD style="padding: 2px;">27</TD><TD style="padding: 2px;">9%</TD></TR><TR><TD style="padding: 2px;">Profit</TD><TD style="padding: 2px;">206</TD><TD style="padding: 2px;">68.7%</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Create-income-statement-table-with-common-size/m-p/1434327#M818653 katetsan 2020-11-25T16:16:04Z Re: Create income statement table with common size https://community.qlik.com/t5/QlikView/Create-income-statement-table-with-common-size/m-p/1434328#M818654 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Duplicate thread &amp; help to close this, replied in your another post with same question. </P><P><A href="https://community.qlik.com/thread/271814">Create income statement table with common size percentage</A></P></BODY></HTML> Mon, 21 Aug 2017 08:20:38 GMT https://community.qlik.com/t5/QlikView/Create-income-statement-table-with-common-size/m-p/1434328#M818654 devarasu07 2017-08-21T08:20:38Z