topic Re: Rolling sum to display in quarter in QlikView https://community.qlik.com/t5/QlikView/Rolling-sum-to-display-in-quarter/m-p/389241#M701955 <HTML><HEAD></HEAD><BODY><P>can you please make it crear what you want exactly?</P><P></P><P></P><P>Sunil</P></BODY></HTML> Sun, 07 Oct 2012 15:00:02 GMT SunilChauhan 2012-10-07T15:00:02Z Rolling sum to display in quarter https://community.qlik.com/t5/QlikView/Rolling-sum-to-display-in-quarter/m-p/389240#M701954 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I am getting the rollup&nbsp; sum value for every month .In a pivot table i need to show the latest month only by quarter wise .</P><P></P><P>Quarter,Month,Value</P><P>Q1,Nov,17000</P><P>Q1,Dec,18000</P><P>Q1,Jan,18500</P><P>Q2,feb,19000</P><P>Q2,Mar,19000</P><P></P><P></P><P>Now i want to display in this way using <STRONG>Pivot Table show only the latest month in Total</STRONG></P><P></P><P>Q1,Nov,17000</P><P>Q1,Dec,18000</P><P>Q1,Jan,18500</P><P>Total&nbsp;&nbsp;&nbsp;&nbsp; 18500</P><P>Q2,feb,19000</P><P>Q2,Mar,19000</P><P>Total&nbsp;&nbsp;&nbsp;&nbsp; 19000</P></BODY></HTML> Sun, 07 Oct 2012 14:46:44 GMT https://community.qlik.com/t5/QlikView/Rolling-sum-to-display-in-quarter/m-p/389240#M701954 sreenivas 2012-10-07T14:46:44Z Re: Rolling sum to display in quarter https://community.qlik.com/t5/QlikView/Rolling-sum-to-display-in-quarter/m-p/389241#M701955 <HTML><HEAD></HEAD><BODY><P>can you please make it crear what you want exactly?</P><P></P><P></P><P>Sunil</P></BODY></HTML> Sun, 07 Oct 2012 15:00:02 GMT https://community.qlik.com/t5/QlikView/Rolling-sum-to-display-in-quarter/m-p/389241#M701955 SunilChauhan 2012-10-07T15:00:02Z Re: Rolling sum to display in quarter https://community.qlik.com/t5/QlikView/Rolling-sum-to-display-in-quarter/m-p/389242#M701956 <HTML><HEAD></HEAD><BODY><P>Hi Sunil</P><P></P><P>I have attached Qvw file in that file a pivot&nbsp; table is created . In pivot table the SUb total for monthName should be shown&nbsp; for latest month.</P><P>In my calendar November is the starting Month.</P><P></P><P>For&nbsp;&nbsp;&nbsp;&nbsp; Q1 the subtotal should be <STRONG>Jan</STRONG> Value </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Q2 Apr Value</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Q3 Jul Value</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Q4 Oct Value</P></BODY></HTML> Sun, 07 Oct 2012 16:09:19 GMT https://community.qlik.com/t5/QlikView/Rolling-sum-to-display-in-quarter/m-p/389242#M701956 sreenivas 2012-10-07T16:09:19Z Re: Rolling sum to display in quarter https://community.qlik.com/t5/QlikView/Rolling-sum-to-display-in-quarter/m-p/389243#M701957 <HTML><HEAD></HEAD><BODY><P>Hi Sunil</P><P>Did you understand my requirement?</P></BODY></HTML> Mon, 08 Oct 2012 09:13:44 GMT https://community.qlik.com/t5/QlikView/Rolling-sum-to-display-in-quarter/m-p/389243#M701957 sreenivas 2012-10-08T09:13:44Z Re: Rolling sum to display in quarter https://community.qlik.com/t5/QlikView/Rolling-sum-to-display-in-quarter/m-p/389244#M701958 <HTML><HEAD></HEAD><BODY><P>HAI SRENNI</P><P></P><P>U HAD THAT QUARTER KA ANSWER</P></BODY></HTML> Sat, 05 Jan 2013 11:06:28 GMT https://community.qlik.com/t5/QlikView/Rolling-sum-to-display-in-quarter/m-p/389244#M701958 2013-01-05T11:06:28Z Re: Rolling sum to display in quarter https://community.qlik.com/t5/QlikView/Rolling-sum-to-display-in-quarter/m-p/389245#M701959 <HTML><HEAD></HEAD><BODY><P>PFA of Solution.</P></BODY></HTML> Wed, 09 Jan 2013 12:49:52 GMT https://community.qlik.com/t5/QlikView/Rolling-sum-to-display-in-quarter/m-p/389245#M701959 sreenivas 2013-01-09T12:49:52Z