topic Percentage subtotal in QlikView https://community.qlik.com/t5/QlikView/Percentage-subtotal/m-p/598489#M682901 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I need to distribute 100% by each month and also by Brand, so the Brand should be the 100%.</P><P></P><P>First i tried with this formula wich is correct by month:&nbsp;&nbsp; </P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN> (</SPAN><SPAN style="color: #800000; font-size: 8pt;">NUM_PAX_BKD_LB</SPAN><SPAN style="font-size: 8pt;">)/ </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;"> (</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">total</SPAN><SPAN style="font-size: 8pt;"> &lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Quarter Cruise]</SPAN><SPAN style="font-size: 8pt;">&gt;(</SPAN><SPAN style="color: #800000; font-size: 8pt;">NUM_PAX_BKD_LB</SPAN><SPAN style="font-size: 8pt;">) ) </SPAN></P><P></P><P></P><P>And this is the result&nbsp; </P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 648px;"><TBODY><TR><TD class="xl63" height="17" width="98"> </TD><TD class="xl64" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="98">Quarter Cruise</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="59">Q1</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="54">Q1</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="59">Q2</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="54">Q2</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="59">Q3</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="54">Q3</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="59">Q4</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="54">Q4</TD></TR><TR><TD class="xl66" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">Brand</TD><TD class="xl67" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;">Fare Type</TD><TD class="xl65" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">#</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">%Month</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">#</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">%Month</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">#</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">%Month</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">#</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">%Month</TD></TR><TR><TD class="xl68" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">Total</TD><TD class="xl69" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;"> </TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">10.372</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">100%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">15.627</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">100%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">26.778</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">100%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">7.662</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">100%</TD></TR><TR><TD class="xl74" height="17">xxx</TD><TD class="xl69" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">Total</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">5.809</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">56%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">7.081</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">45%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">12.598</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">47%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">2.512</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">33%</TD></TR><TR><TD class="xl75" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">xxx</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">GRP</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">604</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">6%</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">294</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">2%</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">34</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0%</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD></TR><TR><TD class="xl75" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">xxx</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">HM</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">46</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0%</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">419</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">3%</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">1.032</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">4%</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">486</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">6%</TD></TR><TR><TD class="xl76" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">xxx</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">IND</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">5.159</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">50%</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">6.368</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">41%</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">11.532</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">43%</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">2.026</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">26%</TD></TR><TR><TD class="xl74" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">YYY</TD><TD class="xl69" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">Total</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">4.563</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">44%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">8.546</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">55%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">14.180</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">53%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">5.150</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">67%</TD></TR><TR><TD class="xl75" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">YYY</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">GRP</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">912</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">9%</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">1.165</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">7%</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD></TR><TR><TD class="xl75" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">YYY</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">HM</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">16</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0%</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">22</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0%</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">231</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">1%</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">112</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">1%</TD></TR><TR><TD class="xl76" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">YYY</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">IND</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">3.635</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">35%</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">7.359</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">47%</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">13.949</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">52%</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">5.038</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">66%</TD></TR></TBODY></TABLE><P></P><P><SPAN style="font-size: 10pt; font-family: Helv;">But what i need is also to fix the Brand and get a tablke like this one:</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Thanks!</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 642px;"><TBODY><TR><TD class="xl65" height="18" width="98"> </TD><TD class="xl66" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="98">Quarter Cruise</TD><TD class="xl67" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="59">Q1</TD><TD class="xl67" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="54">Q1</TD><TD class="xl67" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="59">Q2</TD><TD class="xl67" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="54">Q2</TD><TD class="xl67" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="59">Q3</TD><TD class="xl67" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="54">Q3</TD><TD class="xl67" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="59">Q4</TD><TD class="xl67" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="48">Q4</TD></TR><TR><TD class="xl68" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">Brand</TD><TD class="xl69" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;">Fare Type</TD><TD class="xl67" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">#</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">%Month</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">#</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">%Month</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">#</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">%Month</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">#</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">%Month</TD></TR><TR><TD class="xl72" height="17">xxx</TD><TD class="xl73">Total</TD><TD align="right" class="xl74" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;">5.809</TD><TD align="right" class="xl75" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;">100%</TD><TD align="right" class="xl74" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;">7.081</TD><TD align="right" class="xl75" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;">100%</TD><TD align="right" class="xl74" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;">12.598</TD><TD align="right" class="xl75" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;">100%</TD><TD align="right" class="xl74" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;">2.512</TD><TD align="right" class="xl75" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;">100%</TD></TR><TR><TD class="xl76" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">xxx</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">GRP</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">604</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">10%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">294</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">4%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">34</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0%</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD><TD class="xl77" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD></TR><TR><TD class="xl76" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">xxx</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">HM</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">46</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">1%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">419</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">6%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">1.032</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">8%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">486</TD><TD align="right" class="xl83" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">19%</TD></TR><TR><TD class="xl78" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">xxx</TD><TD class="xl79" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">IND</TD><TD align="right" class="xl80" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">5.159</TD><TD align="right" class="xl82" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">89%</TD><TD align="right" class="xl80" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">6.368</TD><TD align="right" class="xl82" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">90%</TD><TD align="right" class="xl80" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">11.532</TD><TD align="right" class="xl82" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">92%</TD><TD align="right" class="xl80" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">2.026</TD><TD align="right" class="xl81" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">81%</TD></TR><TR><TD class="xl72" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">YYY</TD><TD class="xl73" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">Total</TD><TD align="right" class="xl74" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">4.563</TD><TD align="right" class="xl75" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">100%</TD><TD align="right" class="xl74" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">8.546</TD><TD align="right" class="xl75" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">100%</TD><TD align="right" class="xl74" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">14.180</TD><TD align="right" class="xl75" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">100%</TD><TD align="right" class="xl74" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">5.150</TD><TD align="right" class="xl75" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">100%</TD></TR><TR><TD class="xl76" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">YYY</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">GRP</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">912</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">20%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">1.165</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">14%</TD><TD class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD><TD class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD><TD class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD><TD class="xl84" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD></TR><TR><TD class="xl76" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">YYY</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">HM</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">16</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">22</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">231</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">2%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">112</TD><TD align="right" class="xl83" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">2%</TD></TR><TR><TD class="xl78" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">YYY</TD><TD class="xl79" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">IND</TD><TD align="right" class="xl80" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">3.635</TD><TD align="right" class="xl82" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">80%</TD><TD align="right" class="xl80" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">7.359</TD><TD align="right" class="xl82" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">86%</TD><TD align="right" class="xl80" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">13.949</TD><TD align="right" class="xl82" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">98%</TD><TD align="right" class="xl80" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">5.038</TD><TD align="right" class="xl81" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;"><P>98%</P></TD></TR></TBODY></TABLE><P></P></BODY></HTML> Tue, 04 Mar 2014 16:11:27 GMT 2014-03-04T16:11:27Z Percentage subtotal https://community.qlik.com/t5/QlikView/Percentage-subtotal/m-p/598489#M682901 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I need to distribute 100% by each month and also by Brand, so the Brand should be the 100%.</P><P></P><P>First i tried with this formula wich is correct by month:&nbsp;&nbsp; </P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN> (</SPAN><SPAN style="color: #800000; font-size: 8pt;">NUM_PAX_BKD_LB</SPAN><SPAN style="font-size: 8pt;">)/ </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;"> (</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">total</SPAN><SPAN style="font-size: 8pt;"> &lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Quarter Cruise]</SPAN><SPAN style="font-size: 8pt;">&gt;(</SPAN><SPAN style="color: #800000; font-size: 8pt;">NUM_PAX_BKD_LB</SPAN><SPAN style="font-size: 8pt;">) ) </SPAN></P><P></P><P></P><P>And this is the result&nbsp; </P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 648px;"><TBODY><TR><TD class="xl63" height="17" width="98"> </TD><TD class="xl64" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="98">Quarter Cruise</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="59">Q1</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="54">Q1</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="59">Q2</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="54">Q2</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="59">Q3</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="54">Q3</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="59">Q4</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="54">Q4</TD></TR><TR><TD class="xl66" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">Brand</TD><TD class="xl67" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;">Fare Type</TD><TD class="xl65" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">#</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">%Month</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">#</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">%Month</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">#</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">%Month</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">#</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">%Month</TD></TR><TR><TD class="xl68" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">Total</TD><TD class="xl69" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;"> </TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">10.372</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">100%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">15.627</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">100%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">26.778</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">100%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">7.662</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">100%</TD></TR><TR><TD class="xl74" height="17">xxx</TD><TD class="xl69" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">Total</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">5.809</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">56%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">7.081</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">45%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">12.598</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">47%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">2.512</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">33%</TD></TR><TR><TD class="xl75" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">xxx</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">GRP</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">604</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">6%</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">294</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">2%</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">34</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0%</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD></TR><TR><TD class="xl75" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">xxx</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">HM</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">46</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0%</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">419</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">3%</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">1.032</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">4%</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">486</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">6%</TD></TR><TR><TD class="xl76" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">xxx</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">IND</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">5.159</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">50%</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">6.368</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">41%</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">11.532</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">43%</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">2.026</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">26%</TD></TR><TR><TD class="xl74" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">YYY</TD><TD class="xl69" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">Total</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">4.563</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">44%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">8.546</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">55%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">14.180</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">53%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">5.150</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">67%</TD></TR><TR><TD class="xl75" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">YYY</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">GRP</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">912</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">9%</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">1.165</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">7%</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD></TR><TR><TD class="xl75" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">YYY</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">HM</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">16</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0%</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">22</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0%</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">231</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">1%</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">112</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">1%</TD></TR><TR><TD class="xl76" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">YYY</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">IND</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">3.635</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">35%</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">7.359</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">47%</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">13.949</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">52%</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">5.038</TD><TD align="right" class="xl73" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">66%</TD></TR></TBODY></TABLE><P></P><P><SPAN style="font-size: 10pt; font-family: Helv;">But what i need is also to fix the Brand and get a tablke like this one:</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Thanks!</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 642px;"><TBODY><TR><TD class="xl65" height="18" width="98"> </TD><TD class="xl66" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="98">Quarter Cruise</TD><TD class="xl67" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="59">Q1</TD><TD class="xl67" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="54">Q1</TD><TD class="xl67" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="59">Q2</TD><TD class="xl67" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="54">Q2</TD><TD class="xl67" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="59">Q3</TD><TD class="xl67" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="54">Q3</TD><TD class="xl67" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="59">Q4</TD><TD class="xl67" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="48">Q4</TD></TR><TR><TD class="xl68" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">Brand</TD><TD class="xl69" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;">Fare Type</TD><TD class="xl67" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">#</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">%Month</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">#</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">%Month</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">#</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">%Month</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">#</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">%Month</TD></TR><TR><TD class="xl72" height="17">xxx</TD><TD class="xl73">Total</TD><TD align="right" class="xl74" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;">5.809</TD><TD align="right" class="xl75" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;">100%</TD><TD align="right" class="xl74" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;">7.081</TD><TD align="right" class="xl75" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;">100%</TD><TD align="right" class="xl74" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;">12.598</TD><TD align="right" class="xl75" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;">100%</TD><TD align="right" class="xl74" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;">2.512</TD><TD align="right" class="xl75" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;">100%</TD></TR><TR><TD class="xl76" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">xxx</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">GRP</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">604</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">10%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">294</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">4%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">34</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0%</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD><TD class="xl77" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD></TR><TR><TD class="xl76" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">xxx</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">HM</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">46</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">1%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">419</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">6%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">1.032</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">8%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">486</TD><TD align="right" class="xl83" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">19%</TD></TR><TR><TD class="xl78" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">xxx</TD><TD class="xl79" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">IND</TD><TD align="right" class="xl80" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">5.159</TD><TD align="right" class="xl82" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">89%</TD><TD align="right" class="xl80" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">6.368</TD><TD align="right" class="xl82" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">90%</TD><TD align="right" class="xl80" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">11.532</TD><TD align="right" class="xl82" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">92%</TD><TD align="right" class="xl80" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">2.026</TD><TD align="right" class="xl81" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">81%</TD></TR><TR><TD class="xl72" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">YYY</TD><TD class="xl73" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">Total</TD><TD align="right" class="xl74" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">4.563</TD><TD align="right" class="xl75" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">100%</TD><TD align="right" class="xl74" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">8.546</TD><TD align="right" class="xl75" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">100%</TD><TD align="right" class="xl74" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">14.180</TD><TD align="right" class="xl75" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">100%</TD><TD align="right" class="xl74" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">5.150</TD><TD align="right" class="xl75" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">100%</TD></TR><TR><TD class="xl76" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">YYY</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">GRP</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">912</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">20%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">1.165</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">14%</TD><TD class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD><TD class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD><TD class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD><TD class="xl84" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-</TD></TR><TR><TD class="xl76" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">YYY</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">HM</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">16</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">22</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">231</TD><TD align="right" class="xl71" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">2%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">112</TD><TD align="right" class="xl83" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">2%</TD></TR><TR><TD class="xl78" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">YYY</TD><TD class="xl79" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">IND</TD><TD align="right" class="xl80" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">3.635</TD><TD align="right" class="xl82" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">80%</TD><TD align="right" class="xl80" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">7.359</TD><TD align="right" class="xl82" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">86%</TD><TD align="right" class="xl80" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">13.949</TD><TD align="right" class="xl82" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">98%</TD><TD align="right" class="xl80" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">5.038</TD><TD align="right" class="xl81" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;"><P>98%</P></TD></TR></TBODY></TABLE><P></P></BODY></HTML> Tue, 04 Mar 2014 16:11:27 GMT https://community.qlik.com/t5/QlikView/Percentage-subtotal/m-p/598489#M682901 2014-03-04T16:11:27Z Re: Percentage subtotal https://community.qlik.com/t5/QlikView/Percentage-subtotal/m-p/598490#M682902 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 8pt; font-family: inherit; color: #0000ff;">sum</SPAN> (</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">NUM_PAX_BKD_LB</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">)/ </SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">sum</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"> (</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">total</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"> &lt;</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">[Quarter Cruise], Brand</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&gt;(</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">NUM_PAX_BKD_LB</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">) )</SPAN></P><P><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></SPAN></P><P><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">or </SPAN></P><P><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></SPAN></P><P><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 8pt; font-family: inherit; color: #0000ff;">sum</SPAN> (</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">NUM_PAX_BKD_LB</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">)/ </SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">sum</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"> (</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">total</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"> &lt;</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">[Quarter Cruise], Brand, [<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.800000190734863px;">Fare Type</SPAN>]</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&gt;(</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">NUM_PAX_BKD_LB</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">) )</SPAN></SPAN></P></BODY></HTML> Tue, 04 Mar 2014 16:12:28 GMT https://community.qlik.com/t5/QlikView/Percentage-subtotal/m-p/598490#M682902 MK_QSL 2014-03-04T16:12:28Z Re: Percentage subtotal https://community.qlik.com/t5/QlikView/Percentage-subtotal/m-p/598491#M682903 <HTML><HEAD></HEAD><BODY><P>Thanks!</P></BODY></HTML> Tue, 04 Mar 2014 16:24:38 GMT https://community.qlik.com/t5/QlikView/Percentage-subtotal/m-p/598491#M682903 2014-03-04T16:24:38Z