topic Show Last 18 Months Data in QlikView https://community.qlik.com/t5/QlikView/Show-Last-18-Months-Data/m-p/923582#M979235 <HTML><HEAD></HEAD><BODY><P>Hi There </P><P></P><P>I have requirement like below , in below table we can see Time Period. I want to show Time Period as Columns and show respected revenue for that time period.</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap">No<STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>RLTV_MNTH</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Time_Period</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><STRONG>Total Revenue($)</STRONG></TH><TH nowrap="nowrap"><STRONG>Header 4</STRONG></TH><TH nowrap="nowrap"><STRONG>Header 4</STRONG></TH></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff">PM0<P></P></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Apr 2015</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap">$100</TD><TD bgcolor="#ffffff" nowrap="nowrap">a</TD><TD bgcolor="#ffffff" nowrap="nowrap">q</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PM(1)</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-1</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Mar 2015</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap">$200</TD><TD bgcolor="#ffffff" nowrap="nowrap">a</TD><TD bgcolor="#ffffff" nowrap="nowrap">q</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PM(2)</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-2</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Feb 2015</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap">$100</TD><TD bgcolor="#ffffff" nowrap="nowrap">a</TD><TD bgcolor="#ffffff" nowrap="nowrap">q</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PM(3)</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-3</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Jan 2015</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap">$100</TD><TD bgcolor="#ffffff" nowrap="nowrap">a</TD><TD bgcolor="#ffffff" nowrap="nowrap">wq</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PM(4)</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-4</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Dec 2014</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap">$100</TD><TD bgcolor="#ffffff" nowrap="nowrap">a</TD><TD bgcolor="#ffffff" nowrap="nowrap">eqe</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PM(5)</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-5</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Nov 2014</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap">$100</TD><TD bgcolor="#ffffff" nowrap="nowrap">a</TD><TD bgcolor="#ffffff" nowrap="nowrap">qwe</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PM(6)</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-6</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Oct 2014</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap">$100</TD><TD bgcolor="#ffffff" nowrap="nowrap"></TD><TD bgcolor="#ffffff" nowrap="nowrap">qe</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PM(7)</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-7</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Sep 2014</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap">$100</TD><TD bgcolor="#ffffff" nowrap="nowrap">s</TD><TD bgcolor="#ffffff" nowrap="nowrap">q</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PM(8)</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-8</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Aug 2014</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap">$100</TD><TD bgcolor="#ffffff" nowrap="nowrap">s</TD><TD bgcolor="#ffffff" nowrap="nowrap">eqwe</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PM(9)</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-9</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Jul 2014</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap">$100</TD><TD bgcolor="#ffffff" nowrap="nowrap">s</TD><TD bgcolor="#ffffff" nowrap="nowrap">q</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PM(10)</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-10</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Jun 2014</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap">$100</TD><TD bgcolor="#ffffff" nowrap="nowrap">s</TD><TD bgcolor="#ffffff" nowrap="nowrap">eq</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PM(11)</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-11</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">May 2014</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap">$100</TD><TD bgcolor="#ffffff" nowrap="nowrap">s</TD><TD bgcolor="#ffffff" nowrap="nowrap">weq</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PM(12)</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-12</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Apr 2014</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap">$100</TD><TD bgcolor="#ffffff" nowrap="nowrap">fs</TD><TD bgcolor="#ffffff" nowrap="nowrap">eq</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PM(13)</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-13</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Mar 2014</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap">$100</TD><TD bgcolor="#ffffff" nowrap="nowrap">ff</TD><TD bgcolor="#ffffff" nowrap="nowrap">we</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PM(14)</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-14</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Feb 2014</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap">500</TD><TD bgcolor="#ffffff" nowrap="nowrap">d</TD><TD bgcolor="#ffffff" nowrap="nowrap">qwe</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PM(15)</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-15</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Jan 2014</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap">600</TD><TD bgcolor="#ffffff" nowrap="nowrap">f</TD><TD bgcolor="#ffffff" nowrap="nowrap">qe</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PM(16)</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-16</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Dec 2013</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap">700</TD><TD bgcolor="#ffffff" nowrap="nowrap">f</TD><TD bgcolor="#ffffff" nowrap="nowrap">qe</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PM(17)</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-17</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Nov 2013</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap">800</TD><TD bgcolor="#ffffff" nowrap="nowrap">f</TD><TD bgcolor="#ffffff" nowrap="nowrap">q</TD></TR></TBODY></TABLE><P></P><P></P><P></P><P>Required Output Needed</P><P></P><P></P><P></P><TABLE border="1" cellpadding="0" cellspacing="0" style="background: white; border: outset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;" width="1402"><TBODY><TR><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG style="color: #363636; font-size: 9.0pt; font-family: 'Times New Roman','serif';">No</STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P><STRONG style="color: #363636; font-size: 9.0pt; font-family: 'Times New Roman','serif';">Header 4</STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P><STRONG style="color: #363636; font-size: 9.0pt; font-family: 'Times New Roman','serif';">Header 5</STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG style="color: #363636; font-size: 9.0pt; font-family: 'Times New Roman','serif';">Total Revenue </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Jan 2014</SPAN> </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Feb 2014</SPAN> </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Mar 2014</SPAN> </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Apr 2014</SPAN> </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">May 2014</SPAN> </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Jun 2014</SPAN> </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Jul 2014</SPAN> </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Aug 2014</SPAN> </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Sep 2014</SPAN> </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Oct 2014</SPAN> </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Nov 2014</SPAN> </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Dec 2014</SPAN> </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Jan 2015</SPAN> </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Feb 2015</SPAN> </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Mar 2015</SPAN> </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Apr 2015</SPAN> </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">May 2015</SPAN> </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Jun 2015</SPAN> </STRONG></P></TD></TR><TR><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: black;">PM0</SPAN></P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">A</SPAN></P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">www</SPAN></P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$6831.07</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$4387.76</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$2443.31</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD></TR><TR><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Pm1</SPAN></P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Ba</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">2ad</SPAN></P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$390.13</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$269.75</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$120.38</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD></TR><TR><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: black;">Pm2 </SPAN></P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">ww</SPAN></P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">assas</SPAN></P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$2586.71</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$1516.37</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$1070.34</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN></P></TD></TR></TBODY></TABLE><P></P><P>Thanks in advance. </P></BODY></HTML> Thu, 13 Aug 2015 21:13:20 GMT ashishpalkar 2015-08-13T21:13:20Z Show Last 18 Months Data https://community.qlik.com/t5/QlikView/Show-Last-18-Months-Data/m-p/923582#M979235 <HTML><HEAD></HEAD><BODY><P>Hi There </P><P></P><P>I have requirement like below , in below table we can see Time Period. I want to show Time Period as Columns and show respected revenue for that time period.</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap">No<STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>RLTV_MNTH</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Time_Period</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><STRONG>Total Revenue($)</STRONG></TH><TH nowrap="nowrap"><STRONG>Header 4</STRONG></TH><TH nowrap="nowrap"><STRONG>Header 4</STRONG></TH></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff">PM0<P></P></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Apr 2015</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap">$100</TD><TD bgcolor="#ffffff" nowrap="nowrap">a</TD><TD bgcolor="#ffffff" nowrap="nowrap">q</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PM(1)</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-1</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Mar 2015</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap">$200</TD><TD bgcolor="#ffffff" nowrap="nowrap">a</TD><TD bgcolor="#ffffff" nowrap="nowrap">q</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PM(2)</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-2</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Feb 2015</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap">$100</TD><TD bgcolor="#ffffff" nowrap="nowrap">a</TD><TD bgcolor="#ffffff" nowrap="nowrap">q</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PM(3)</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-3</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Jan 2015</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap">$100</TD><TD bgcolor="#ffffff" nowrap="nowrap">a</TD><TD bgcolor="#ffffff" nowrap="nowrap">wq</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PM(4)</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-4</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Dec 2014</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap">$100</TD><TD bgcolor="#ffffff" nowrap="nowrap">a</TD><TD bgcolor="#ffffff" nowrap="nowrap">eqe</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PM(5)</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-5</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Nov 2014</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap">$100</TD><TD bgcolor="#ffffff" nowrap="nowrap">a</TD><TD bgcolor="#ffffff" nowrap="nowrap">qwe</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PM(6)</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-6</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Oct 2014</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap">$100</TD><TD bgcolor="#ffffff" nowrap="nowrap"></TD><TD bgcolor="#ffffff" nowrap="nowrap">qe</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PM(7)</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-7</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Sep 2014</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap">$100</TD><TD bgcolor="#ffffff" nowrap="nowrap">s</TD><TD bgcolor="#ffffff" nowrap="nowrap">q</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PM(8)</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-8</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Aug 2014</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap">$100</TD><TD bgcolor="#ffffff" nowrap="nowrap">s</TD><TD bgcolor="#ffffff" nowrap="nowrap">eqwe</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PM(9)</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-9</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Jul 2014</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap">$100</TD><TD bgcolor="#ffffff" nowrap="nowrap">s</TD><TD bgcolor="#ffffff" nowrap="nowrap">q</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PM(10)</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-10</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Jun 2014</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap">$100</TD><TD bgcolor="#ffffff" nowrap="nowrap">s</TD><TD bgcolor="#ffffff" nowrap="nowrap">eq</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PM(11)</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-11</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">May 2014</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap">$100</TD><TD bgcolor="#ffffff" nowrap="nowrap">s</TD><TD bgcolor="#ffffff" nowrap="nowrap">weq</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PM(12)</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-12</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Apr 2014</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap">$100</TD><TD bgcolor="#ffffff" nowrap="nowrap">fs</TD><TD bgcolor="#ffffff" nowrap="nowrap">eq</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PM(13)</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-13</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Mar 2014</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap">$100</TD><TD bgcolor="#ffffff" nowrap="nowrap">ff</TD><TD bgcolor="#ffffff" nowrap="nowrap">we</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PM(14)</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-14</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Feb 2014</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap">500</TD><TD bgcolor="#ffffff" nowrap="nowrap">d</TD><TD bgcolor="#ffffff" nowrap="nowrap">qwe</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PM(15)</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-15</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Jan 2014</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap">600</TD><TD bgcolor="#ffffff" nowrap="nowrap">f</TD><TD bgcolor="#ffffff" nowrap="nowrap">qe</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PM(16)</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-16</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Dec 2013</SPAN> </TD><TD bgcolor="#ffffff" nowrap="nowrap">700</TD><TD bgcolor="#ffffff" nowrap="nowrap">f</TD><TD bgcolor="#ffffff" nowrap="nowrap">qe</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PM(17)</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-17</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap"><SPAN style="color: #363636;">Nov 2013</SPAN></TD><TD bgcolor="#ffffff" nowrap="nowrap">800</TD><TD bgcolor="#ffffff" nowrap="nowrap">f</TD><TD bgcolor="#ffffff" nowrap="nowrap">q</TD></TR></TBODY></TABLE><P></P><P></P><P></P><P>Required Output Needed</P><P></P><P></P><P></P><TABLE border="1" cellpadding="0" cellspacing="0" style="background: white; border: outset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;" width="1402"><TBODY><TR><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG style="color: #363636; font-size: 9.0pt; font-family: 'Times New Roman','serif';">No</STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P><STRONG style="color: #363636; font-size: 9.0pt; font-family: 'Times New Roman','serif';">Header 4</STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P><STRONG style="color: #363636; font-size: 9.0pt; font-family: 'Times New Roman','serif';">Header 5</STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG style="color: #363636; font-size: 9.0pt; font-family: 'Times New Roman','serif';">Total Revenue </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Jan 2014</SPAN> </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Feb 2014</SPAN> </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Mar 2014</SPAN> </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Apr 2014</SPAN> </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">May 2014</SPAN> </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Jun 2014</SPAN> </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Jul 2014</SPAN> </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Aug 2014</SPAN> </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Sep 2014</SPAN> </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Oct 2014</SPAN> </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Nov 2014</SPAN> </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Dec 2014</SPAN> </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Jan 2015</SPAN> </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Feb 2015</SPAN> </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Mar 2015</SPAN> </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Apr 2015</SPAN> </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">May 2015</SPAN> </STRONG></P></TD><TD nowrap="nowrap" style="border: inset silver 1.0pt; background: whitesmoke; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="center" style="text-align: center;"><STRONG><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Jun 2015</SPAN> </STRONG></P></TD></TR><TR><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: black;">PM0</SPAN></P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">A</SPAN></P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">www</SPAN></P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$6831.07</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$4387.76</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$2443.31</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD></TR><TR><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Pm1</SPAN></P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">Ba</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">2ad</SPAN></P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$390.13</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$269.75</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$120.38</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD></TR><TR><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: black;">Pm2 </SPAN></P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">ww</SPAN></P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">assas</SPAN></P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$2586.71</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$1516.37</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$1070.34</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN> </P></TD><TD style="border: inset silver 1.0pt; padding: 1.5pt 1.5pt 1.5pt 1.5pt;"><P align="right" style="text-align: right;"><SPAN style="font-size: 9.0pt; font-family: 'Times New Roman','serif'; color: #363636;">$0.00</SPAN></P></TD></TR></TBODY></TABLE><P></P><P>Thanks in advance. </P></BODY></HTML> Thu, 13 Aug 2015 21:13:20 GMT https://community.qlik.com/t5/QlikView/Show-Last-18-Months-Data/m-p/923582#M979235 ashishpalkar 2015-08-13T21:13:20Z Re: Show Last 18 Months Data https://community.qlik.com/t5/QlikView/Show-Last-18-Months-Data/m-p/923583#M979236 <HTML><HEAD></HEAD><BODY><P>use Crosstab() function.</P><P>Or in a pivot table u can pivot the period column.</P><P></P><P>Provide some sample data.</P></BODY></HTML> Thu, 13 Aug 2015 21:20:36 GMT https://community.qlik.com/t5/QlikView/Show-Last-18-Months-Data/m-p/923583#M979236 Qrishna 2015-08-13T21:20:36Z Re: Show Last 18 Months Data https://community.qlik.com/t5/QlikView/Show-Last-18-Months-Data/m-p/923584#M979237 <HTML><HEAD></HEAD><BODY><P>Hi Ashish,</P><P></P><P>a simple pivot chart would do the trick ! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P><P></P><P>HTH - Andy</P></BODY></HTML> Fri, 14 Aug 2015 09:47:35 GMT https://community.qlik.com/t5/QlikView/Show-Last-18-Months-Data/m-p/923584#M979237 awhitfield 2015-08-14T09:47:35Z