https://community.qlik.com/t5/App-Development/Qliksense-Pivot-Table/m-p/1621550#M46270 <P>Hi,</P><P>I have this monthly data that I need to display in a pivot table.</P><P>I am able to display Months as columns, however I need to display Total as a column&nbsp; for all months except last month.</P><P>Say if I have data from Jan-Jul 2019, I need a total column&nbsp; to average only Jan-Jun 2019, and then I need to show other columns for variance of total from July.</P><P>Please suggest how it can be achieved.</P><P><SPAN>Attached is the data file.</SPAN></P><P>Thanks</P> Sat, 16 Nov 2024 20:07:13 GMT reema_dangwal 2024-11-16T20:07:13Z https://community.qlik.com/t5/App-Development/Qliksense-Pivot-Table/m-p/1621550#M46270 <P>Hi,</P><P>I have this monthly data that I need to display in a pivot table.</P><P>I am able to display Months as columns, however I need to display Total as a column&nbsp; for all months except last month.</P><P>Say if I have data from Jan-Jul 2019, I need a total column&nbsp; to average only Jan-Jun 2019, and then I need to show other columns for variance of total from July.</P><P>Please suggest how it can be achieved.</P><P><SPAN>Attached is the data file.</SPAN></P><P>Thanks</P> Sat, 16 Nov 2024 20:07:13 GMT https://community.qlik.com/t5/App-Development/Qliksense-Pivot-Table/m-p/1621550#M46270 reema_dangwal 2024-11-16T20:07:13Z