topic Re: How to show difference in Pivot table in QlikView https://community.qlik.com/t5/QlikView/How-to-show-difference-in-Pivot-table/m-p/864751#M1015993 <HTML><HEAD></HEAD><BODY><P>Does this help? PFA</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Mon, 20 Apr 2015 16:30:29 GMT sunny_talwar 2015-04-20T16:30:29Z How to show difference in Pivot table https://community.qlik.com/t5/QlikView/How-to-show-difference-in-Pivot-table/m-p/864750#M1015992 <HTML><HEAD></HEAD><BODY><P>Hi, I have created a pivot table , looking for solution to give % of change </P><P></P><P><STRONG>Data:</STRONG></P><TABLE border="1" class="jiveBorder" height="74" style="border: 1px solid #000000; width: 145px; height: 44px;" width="143"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Sales rep</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Year</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Sales</TH></TR><TR><TD style="padding: 2px;">John</TD><TD style="padding: 2px;">2014</TD><TD style="padding: 2px;">100</TD></TR><TR><TD>John</TD><TD>2015</TD><TD>150</TD></TR></TBODY></TABLE><P></P><P><STRONG>Pivot Table</STRONG></P><TABLE border="1" class="jiveBorder" height="49" style="border: 1px solid rgb(0, 0, 0); width: 155px; height: 0px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Sales Rep</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>2014</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>2015</STRONG></TH></TR><TR><TD style="padding: 2px;">John</TD><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">150</TD></TR></TBODY></TABLE><P></P><P><STRONG>Output:</STRONG> a row giving % difference of sales over previous year</P><TABLE border="1" class="jiveBorder" height="49" style="border: 1px solid #000000; width: 155px; height: 0px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">es Rep</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>2014</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>2015</STRONG></TH></TR><TR><TD style="padding: 2px;">John</TD><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">150</TD></TR><TR><TD style="padding: 2px;"><SPAN style="color: #0000ff;">% Ch<STRONG>ange</STRONG></SPAN></TD><TD style="padding: 2px;"><SPAN style="color: #0000ff;"><STRONG>0</STRONG></SPAN></TD><TD style="padding: 2px;"><STRONG style="color: #0000ff;">66.7%</STRONG></TD></TR></TBODY></TABLE></BODY></HTML> Mon, 20 Apr 2015 08:31:43 GMT https://community.qlik.com/t5/QlikView/How-to-show-difference-in-Pivot-table/m-p/864750#M1015992 2015-04-20T08:31:43Z Re: How to show difference in Pivot table https://community.qlik.com/t5/QlikView/How-to-show-difference-in-Pivot-table/m-p/864751#M1015993 <HTML><HEAD></HEAD><BODY><P>Does this help? PFA</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Mon, 20 Apr 2015 16:30:29 GMT https://community.qlik.com/t5/QlikView/How-to-show-difference-in-Pivot-table/m-p/864751#M1015993 sunny_talwar 2015-04-20T16:30:29Z