topic Re: Rolling grayed out in QlikView https://community.qlik.com/t5/QlikView/Rolling-grayed-out/m-p/1445044#M433111 <HTML><HEAD></HEAD><BODY><P>"<STRONG>Accumulation</STRONG>" section won't visible for Pivot Table.. </P></BODY></HTML> Thu, 21 Dec 2017 15:55:55 GMT Anil_Babu_Samineni 2017-12-21T15:55:55Z Rolling grayed out https://community.qlik.com/t5/QlikView/Rolling-grayed-out/m-p/1445043#M433110 <HTML><HEAD></HEAD><BODY><P>Anyone knows why the Rolling is grayed out?</P><P>How i can solve this?</P><P></P><P><IMG __jive_id="187831" alt="ROLLING 12 M.png" class="jive-image image-1" src="/legacyfs/online/187831_ROLLING 12 M.png" style="height: 565px; width: 620px;" /></P></BODY></HTML> Thu, 21 Dec 2017 15:53:51 GMT https://community.qlik.com/t5/QlikView/Rolling-grayed-out/m-p/1445043#M433110 qlikviewaf 2017-12-21T15:53:51Z Re: Rolling grayed out https://community.qlik.com/t5/QlikView/Rolling-grayed-out/m-p/1445044#M433111 <HTML><HEAD></HEAD><BODY><P>"<STRONG>Accumulation</STRONG>" section won't visible for Pivot Table.. </P></BODY></HTML> Thu, 21 Dec 2017 15:55:55 GMT https://community.qlik.com/t5/QlikView/Rolling-grayed-out/m-p/1445044#M433111 Anil_Babu_Samineni 2017-12-21T15:55:55Z Re: Rolling grayed out https://community.qlik.com/t5/QlikView/Rolling-grayed-out/m-p/1445045#M433112 <HTML><HEAD></HEAD><BODY><P>Which could be a solution ?</P></BODY></HTML> Thu, 21 Dec 2017 15:57:33 GMT https://community.qlik.com/t5/QlikView/Rolling-grayed-out/m-p/1445045#M433112 qlikviewaf 2017-12-21T15:57:33Z Re: Rolling grayed out https://community.qlik.com/t5/QlikView/Rolling-grayed-out/m-p/1445046#M433113 <HTML><HEAD></HEAD><BODY><P>To overcome in Pivot table? you need to write expression?</P><P></P><P><STRONG>RangeSum(Above(TOTAL <SPAN style="color: #ff0000;">Your Measure</SPAN>, 1, RowNo()))</STRONG></P></BODY></HTML> Thu, 21 Dec 2017 16:00:57 GMT https://community.qlik.com/t5/QlikView/Rolling-grayed-out/m-p/1445046#M433113 Anil_Babu_Samineni 2017-12-21T16:00:57Z Re: Rolling grayed out https://community.qlik.com/t5/QlikView/Rolling-grayed-out/m-p/1445047#M433114 <HTML><HEAD></HEAD><BODY><P>I would like to have the sum of last 12 month based on the maximum "Invoice_date" done on the selection.</P><P></P><P>How this can be build?</P><P></P><P>This is the formula for sales based on the selection (imagine May - 2017)</P><P>=Sum(ExtendedUSD)</P><P></P><P>Which shuold be the formula to retrieve the last 12 month sales ? </P><P>Thanks for clarifing!</P></BODY></HTML> Thu, 21 Dec 2017 16:06:20 GMT https://community.qlik.com/t5/QlikView/Rolling-grayed-out/m-p/1445047#M433114 qlikviewaf 2017-12-21T16:06:20Z