topic creating a pivot table with static columns in QlikView https://community.qlik.com/t5/QlikView/creating-a-pivot-table-with-static-columns/m-p/361485#M1174863 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Am new to Qlikview and am stuck in a scenario where I have to migrate a reporting application in OBI to Qlikview. A sample table looks like below.</P><P></P><P>I needed help on creating such a table. I have taken the option of Pvot table to depict this.</P><P></P><P>Columns B,C,D,E, are fetched from database, while the column A has to be added synthetically . </P><P></P><P>Please help on achieving this.</P><P></P><P></P><P></P><TABLE border="0" cellspacing="0" frame="void" rules="none"><TBODY><TR><TD align="center" bgcolor="#ffffff" height="21" style="border-right: #000000 3px solid; border-left: #ffffff 5px solid;" valign="top" width="70"><STRONG style="color: #3c3c3c; font-family: Verdana;"><BR /></STRONG></TD><TD align="center" bgcolor="#ffffff" colspan="8" style="border-right: #000000 3px solid; border-left: #000000 3px solid; border-bottom: #000000 3px solid;" valign="top" width="562"><STRONG style="color: #3c3c3c; font-family: Verdana;">Actual Results</STRONG></TD><TD align="center" bgcolor="#ffffff" colspan="5" style="border-right: #000000 3px solid; border-left: #000000 3px solid; border-bottom: #000000 3px solid;" valign="top" width="351"><STRONG style="color: #3c3c3c; font-family: Verdana;">Trend</STRONG></TD><TD align="center" bgcolor="#ffffff" colspan="3" style="border-right: #000000 3px solid; border-left: #000000 3px solid; border-bottom: #000000 3px solid;" valign="top" width="211"><STRONG style="color: #3c3c3c; font-family: Verdana;">Actual</STRONG></TD><TD align="center" bgcolor="#ffffff" colspan="4" style="border-right: #ffffff 5px solid; border-left: #000000 3px solid; border-bottom: #000000 3px solid;" valign="top" width="281"><STRONG style="color: #3c3c3c; font-family: Verdana;">YTD</STRONG></TD></TR><TR><TD align="center" bgcolor="#ffffff" height="75" rowspan="4" style="border-right: #000000 3px solid; border-left: #ffffff 5px solid; border-bottom: #000000 3px solid;" valign="top"><STRONG style="color: #ffffff; font-family: Verdana;">X</STRONG></TD><TD align="center" bgcolor="#ffffff" rowspan="4" style="border: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">PY-Q1</STRONG></TD><TD align="center" bgcolor="#ffffff" rowspan="4" style="border: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">PY-Q2</STRONG></TD><TD align="center" bgcolor="#ffffff" rowspan="4" style="border: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">PY-Q3</STRONG></TD><TD align="center" bgcolor="#ffffff" rowspan="4" style="border: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">PY-Q4</STRONG></TD><TD align="center" bgcolor="#ffffff" rowspan="4" style="border: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">CY-Q1</STRONG></TD><TD align="center" bgcolor="#ffffff" rowspan="4" style="border: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">CY-Q2</STRONG></TD><TD align="center" bgcolor="#ffffff" rowspan="4" style="border: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">CY-Q3</STRONG></TD><TD align="center" bgcolor="#ffffff" rowspan="4" style="border: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">CY-Q4</STRONG></TD><TD align="center" bgcolor="#ffffff" rowspan="4" style="border: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">Q1-CY/PY</STRONG></TD><TD align="center" bgcolor="#ffffff" rowspan="4" style="border: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">Q2-CY/PY</STRONG></TD><TD align="center" bgcolor="#ffffff" rowspan="4" style="border: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">Q3-CY/PY</STRONG></TD><TD align="center" bgcolor="#ffffff" rowspan="4" style="border: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">Q4-CY/PY</STRONG></TD><TD align="center" bgcolor="#ffffff" rowspan="4" style="border: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">CY/PY</STRONG></TD><TD align="center" bgcolor="#ffffff" style="border-right: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">12 Month</STRONG></TD><TD align="center" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-left: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">12 Month</STRONG></TD><TD align="center" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-left: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">12 Month</STRONG></TD><TD align="center" bgcolor="#ffffff" rowspan="4" style="border: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">YTD PY</STRONG></TD><TD align="center" bgcolor="#ffffff" rowspan="4" style="border: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">YTD CY</STRONG></TD><TD align="center" bgcolor="#ffffff" rowspan="4" style="border: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">YTD Change</STRONG></TD><TD align="center" bgcolor="#ffffff" rowspan="4" style="border-right: #ffffff 5px solid; border-top: #000000 3px solid; border-left: #000000 3px solid; border-bottom: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">YTD Trend</STRONG></TD></TR><TR><TD align="center" bgcolor="#ffffff" style="border-right: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">actual</STRONG></TD><TD align="center" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-left: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">actual</STRONG></TD><TD align="center" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-left: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">actual</STRONG></TD></TR><TR><TD align="center" bgcolor="#ffffff" style="border-right: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">ending</STRONG></TD><TD align="center" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-left: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">ending</STRONG></TD><TD align="center" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-left: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">change</STRONG></TD></TR><TR><TD align="center" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-bottom: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">PY</STRONG></TD><TD align="center" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-left: #000000 3px solid; border-bottom: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">CY</STRONG></TD><TD align="center" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-left: #000000 3px solid; border-bottom: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;"><BR /></STRONG></TD></TR><TR><TD align="left" bgcolor="#ffffff" height="19" style="border-right: #000000 3px solid; border-left: #ffffff 5px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">A</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">$1,692 </SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #ff0000; font-family: Verdana;">-7.60%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #ff0000; font-family: Verdana;">-6.40%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">1.30%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">1.60%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #ff0000; font-family: Verdana;">-3.00%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #ff0000; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">$1,619 </SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #ff0000; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #ffffff 5px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #ff0000; font-family: Verdana;"><BR /></SPAN></TD></TR><TR><TD align="left" bgcolor="#ffffff" height="19" style="border-right: #000000 3px solid; border-top: #c9cbd3 3px solid; border-left: #ffffff 5px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">B</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">$2,477 </SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #ff0000; font-family: Verdana;">-7.60%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #ff0000; font-family: Verdana;">-5.00%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">3.00%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">1.50%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #ff0000; font-family: Verdana;">-2.30%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #ff0000; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">$2,394 </SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #ff0000; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #ffffff 5px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #ff0000; font-family: Verdana;"><BR /></SPAN></TD></TR><TR><TD align="left" bgcolor="#ffffff" height="19" style="border-right: #000000 3px solid; border-top: #c9cbd3 3px solid; border-left: #ffffff 5px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">C</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">$908 </SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">6.90%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">1.30%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">1.70%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">7.00%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">4.10%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">$924 </SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #ffffff 5px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD></TR><TR><TD align="left" bgcolor="#ffffff" height="19" style="border-right: #000000 3px solid; border-top: #c9cbd3 3px solid; border-left: #ffffff 5px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">D</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">$1,002 </SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">8.70%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">0.60%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">0.50%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #ff0000; font-family: Verdana;">-3.10%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">1.80%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">$1,057 </SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #ffffff 5px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD></TR><TR><TD align="left" bgcolor="#ffffff" height="19" style="border-right: #000000 3px solid; border-top: #c9cbd3 3px solid; border-left: #ffffff 5px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">E</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">$401 </SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">1.80%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">4.20%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">6.30%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #ff0000; font-family: Verdana;">-3.30%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">2.40%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">$392 </SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #ffffff 5px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD></TR><TR><TD align="left" bgcolor="#ffffff" height="19" style="border-right: #000000 3px solid; border-left: #ffffff 5px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">F</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">$1,476 </SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">20.80%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">20.40%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">21.10%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #ff0000; font-family: Verdana;">-5.40%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">14.60%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">$1,503 </SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="left" bgcolor="#ffffff" valign="bottom"><SPAN style="color: #000000; font-family: Calibri;"><BR /></SPAN></TD><TD align="left" bgcolor="#ffffff" style="border-right: #ffffff 5px solid;" valign="bottom"><SPAN style="color: #000000; font-family: Calibri;"><BR /></SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Fri, 20 Apr 2012 12:46:48 GMT sonikajain 2012-04-20T12:46:48Z creating a pivot table with static columns https://community.qlik.com/t5/QlikView/creating-a-pivot-table-with-static-columns/m-p/361485#M1174863 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Am new to Qlikview and am stuck in a scenario where I have to migrate a reporting application in OBI to Qlikview. A sample table looks like below.</P><P></P><P>I needed help on creating such a table. I have taken the option of Pvot table to depict this.</P><P></P><P>Columns B,C,D,E, are fetched from database, while the column A has to be added synthetically . </P><P></P><P>Please help on achieving this.</P><P></P><P></P><P></P><TABLE border="0" cellspacing="0" frame="void" rules="none"><TBODY><TR><TD align="center" bgcolor="#ffffff" height="21" style="border-right: #000000 3px solid; border-left: #ffffff 5px solid;" valign="top" width="70"><STRONG style="color: #3c3c3c; font-family: Verdana;"><BR /></STRONG></TD><TD align="center" bgcolor="#ffffff" colspan="8" style="border-right: #000000 3px solid; border-left: #000000 3px solid; border-bottom: #000000 3px solid;" valign="top" width="562"><STRONG style="color: #3c3c3c; font-family: Verdana;">Actual Results</STRONG></TD><TD align="center" bgcolor="#ffffff" colspan="5" style="border-right: #000000 3px solid; border-left: #000000 3px solid; border-bottom: #000000 3px solid;" valign="top" width="351"><STRONG style="color: #3c3c3c; font-family: Verdana;">Trend</STRONG></TD><TD align="center" bgcolor="#ffffff" colspan="3" style="border-right: #000000 3px solid; border-left: #000000 3px solid; border-bottom: #000000 3px solid;" valign="top" width="211"><STRONG style="color: #3c3c3c; font-family: Verdana;">Actual</STRONG></TD><TD align="center" bgcolor="#ffffff" colspan="4" style="border-right: #ffffff 5px solid; border-left: #000000 3px solid; border-bottom: #000000 3px solid;" valign="top" width="281"><STRONG style="color: #3c3c3c; font-family: Verdana;">YTD</STRONG></TD></TR><TR><TD align="center" bgcolor="#ffffff" height="75" rowspan="4" style="border-right: #000000 3px solid; border-left: #ffffff 5px solid; border-bottom: #000000 3px solid;" valign="top"><STRONG style="color: #ffffff; font-family: Verdana;">X</STRONG></TD><TD align="center" bgcolor="#ffffff" rowspan="4" style="border: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">PY-Q1</STRONG></TD><TD align="center" bgcolor="#ffffff" rowspan="4" style="border: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">PY-Q2</STRONG></TD><TD align="center" bgcolor="#ffffff" rowspan="4" style="border: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">PY-Q3</STRONG></TD><TD align="center" bgcolor="#ffffff" rowspan="4" style="border: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">PY-Q4</STRONG></TD><TD align="center" bgcolor="#ffffff" rowspan="4" style="border: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">CY-Q1</STRONG></TD><TD align="center" bgcolor="#ffffff" rowspan="4" style="border: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">CY-Q2</STRONG></TD><TD align="center" bgcolor="#ffffff" rowspan="4" style="border: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">CY-Q3</STRONG></TD><TD align="center" bgcolor="#ffffff" rowspan="4" style="border: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">CY-Q4</STRONG></TD><TD align="center" bgcolor="#ffffff" rowspan="4" style="border: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">Q1-CY/PY</STRONG></TD><TD align="center" bgcolor="#ffffff" rowspan="4" style="border: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">Q2-CY/PY</STRONG></TD><TD align="center" bgcolor="#ffffff" rowspan="4" style="border: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">Q3-CY/PY</STRONG></TD><TD align="center" bgcolor="#ffffff" rowspan="4" style="border: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">Q4-CY/PY</STRONG></TD><TD align="center" bgcolor="#ffffff" rowspan="4" style="border: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">CY/PY</STRONG></TD><TD align="center" bgcolor="#ffffff" style="border-right: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">12 Month</STRONG></TD><TD align="center" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-left: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">12 Month</STRONG></TD><TD align="center" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-left: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">12 Month</STRONG></TD><TD align="center" bgcolor="#ffffff" rowspan="4" style="border: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">YTD PY</STRONG></TD><TD align="center" bgcolor="#ffffff" rowspan="4" style="border: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">YTD CY</STRONG></TD><TD align="center" bgcolor="#ffffff" rowspan="4" style="border: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">YTD Change</STRONG></TD><TD align="center" bgcolor="#ffffff" rowspan="4" style="border-right: #ffffff 5px solid; border-top: #000000 3px solid; border-left: #000000 3px solid; border-bottom: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">YTD Trend</STRONG></TD></TR><TR><TD align="center" bgcolor="#ffffff" style="border-right: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">actual</STRONG></TD><TD align="center" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-left: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">actual</STRONG></TD><TD align="center" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-left: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">actual</STRONG></TD></TR><TR><TD align="center" bgcolor="#ffffff" style="border-right: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">ending</STRONG></TD><TD align="center" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-left: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">ending</STRONG></TD><TD align="center" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-left: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">change</STRONG></TD></TR><TR><TD align="center" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-bottom: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">PY</STRONG></TD><TD align="center" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-left: #000000 3px solid; border-bottom: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;">CY</STRONG></TD><TD align="center" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-left: #000000 3px solid; border-bottom: #000000 3px solid;" valign="top"><STRONG style="color: #3c3c3c; font-family: Verdana;"><BR /></STRONG></TD></TR><TR><TD align="left" bgcolor="#ffffff" height="19" style="border-right: #000000 3px solid; border-left: #ffffff 5px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">A</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">$1,692 </SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #ff0000; font-family: Verdana;">-7.60%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #ff0000; font-family: Verdana;">-6.40%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">1.30%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">1.60%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #ff0000; font-family: Verdana;">-3.00%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #ff0000; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">$1,619 </SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #ff0000; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #ffffff 5px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #ff0000; font-family: Verdana;"><BR /></SPAN></TD></TR><TR><TD align="left" bgcolor="#ffffff" height="19" style="border-right: #000000 3px solid; border-top: #c9cbd3 3px solid; border-left: #ffffff 5px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">B</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">$2,477 </SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #ff0000; font-family: Verdana;">-7.60%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #ff0000; font-family: Verdana;">-5.00%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">3.00%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">1.50%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #ff0000; font-family: Verdana;">-2.30%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #ff0000; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">$2,394 </SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #ff0000; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #ffffff 5px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #ff0000; font-family: Verdana;"><BR /></SPAN></TD></TR><TR><TD align="left" bgcolor="#ffffff" height="19" style="border-right: #000000 3px solid; border-top: #c9cbd3 3px solid; border-left: #ffffff 5px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">C</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">$908 </SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">6.90%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">1.30%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">1.70%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">7.00%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">4.10%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">$924 </SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #ffffff 5px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD></TR><TR><TD align="left" bgcolor="#ffffff" height="19" style="border-right: #000000 3px solid; border-top: #c9cbd3 3px solid; border-left: #ffffff 5px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">D</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">$1,002 </SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">8.70%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">0.60%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">0.50%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #ff0000; font-family: Verdana;">-3.10%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">1.80%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">$1,057 </SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #ffffff 5px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD></TR><TR><TD align="left" bgcolor="#ffffff" height="19" style="border-right: #000000 3px solid; border-top: #c9cbd3 3px solid; border-left: #ffffff 5px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">E</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">$401 </SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">1.80%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">4.20%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">6.30%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #ff0000; font-family: Verdana;">-3.30%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">2.40%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">$392 </SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #ffffff 5px solid; border-top: #c9cbd3 3px solid; border-bottom: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD></TR><TR><TD align="left" bgcolor="#ffffff" height="19" style="border-right: #000000 3px solid; border-left: #ffffff 5px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">F</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">$1,476 </SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">20.80%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">20.40%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">21.10%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #ff0000; font-family: Verdana;">-5.40%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">14.60%</SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #000000 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;">$1,503 </SPAN></TD><TD align="right" bgcolor="#ffffff" style="border-right: #c9cbd3 3px solid; border-left: #c9cbd3 3px solid;" valign="top"><SPAN style="color: #3c3c3c; font-family: Verdana;"><BR /></SPAN></TD><TD align="left" bgcolor="#ffffff" valign="bottom"><SPAN style="color: #000000; font-family: Calibri;"><BR /></SPAN></TD><TD align="left" bgcolor="#ffffff" style="border-right: #ffffff 5px solid;" valign="bottom"><SPAN style="color: #000000; font-family: Calibri;"><BR /></SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Fri, 20 Apr 2012 12:46:48 GMT https://community.qlik.com/t5/QlikView/creating-a-pivot-table-with-static-columns/m-p/361485#M1174863 sonikajain 2012-04-20T12:46:48Z