topic Re: RangeSum with Average in QlikView https://community.qlik.com/t5/QlikView/RangeSum-with-Average/m-p/1536527#M439191 <P>Sunny,</P><P>Good morning.&nbsp; I was wondering if there is a way to calculate a % of growth using the RangeSum?&nbsp; What I am trying to do is find % of growth over a 11 year period by year.&nbsp; I'm using this for the RangeAvg.&nbsp; Thanks. The first column is actual and the second if from the statement below.</P><P><FONT size="2"><FONT color="#0000ff">RangeAvg</FONT>(<FONT color="#0000ff">Before</FONT>(<FONT color="#0000ff">Count</FONT>({&lt;<FONT color="#800000">YR_SW</FONT> = {1}&gt;}<FONT color="#0000ff">DISTINCT</FONT>(<FONT color="#800000">[Sold To]</FONT></FONT><FONT size="1"><FONT size="2">)),0,11))</FONT> </FONT></P><TABLE border="1" cellspacing="0" cellpadding="2"><TBODY><TR><TD><FONT color="#363636">Great Lakes Central</FONT></TD><TD><FONT color="#363636">11753</FONT></TD><TD><FONT color="#363636">11753</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">10697</FONT></TD><TD><FONT color="#363636">11225</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">10935</FONT></TD><TD><FONT color="#363636">11128</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">11417</FONT></TD><TD><FONT color="#363636">11201</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">11513</FONT></TD><TD><FONT color="#363636">11263</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">11440</FONT></TD><TD><FONT color="#363636">11293</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">12014</FONT></TD><TD><FONT color="#363636">11396</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">12116</FONT></TD><TD><FONT color="#363636">11486</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">13099</FONT></TD><TD><FONT color="#363636">11665</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">13362</FONT></TD><TD><FONT color="#363636">11835</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">13184</FONT></TD><TD><FONT color="#363636">11957</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">Great Lakes E</FONT></TD><TD><FONT color="#363636">16859</FONT></TD><TD><FONT color="#363636">16859</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">16081</FONT></TD><TD><FONT color="#363636">16470</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">16508</FONT></TD><TD><FONT color="#363636">16483</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">16684</FONT></TD><TD><FONT color="#363636">16533</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">16749</FONT></TD><TD><FONT color="#363636">16576</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">17135</FONT></TD><TD><FONT color="#363636">16669</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">17536</FONT></TD><TD><FONT color="#363636">16793</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">17730</FONT></TD><TD><FONT color="#363636">16910</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">18364</FONT></TD><TD><FONT color="#363636">17072</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">20011</FONT></TD><TD><FONT color="#363636">17366</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">19781</FONT></TD><TD><FONT color="#363636">17585</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">Great Lakes W</FONT></TD><TD><FONT color="#363636">11117</FONT></TD><TD><FONT color="#363636">11117</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">10601</FONT></TD><TD><FONT color="#363636">10859</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">10881</FONT></TD><TD><FONT color="#363636">10866</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">11262</FONT></TD><TD><FONT color="#363636">10965</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">11240</FONT></TD><TD><FONT color="#363636">11020</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">11685</FONT></TD><TD><FONT color="#363636">11131</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">17360</FONT></TD><TD><FONT color="#363636">12021</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">18131</FONT></TD><TD><FONT color="#363636">12785</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">19272</FONT></TD><TD><FONT color="#363636">13505</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">20395</FONT></TD><TD><FONT color="#363636">14194</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">20869</FONT></TD><TD><FONT color="#363636">14801</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">Mid Atlantic</FONT></TD><TD><FONT color="#363636">9416</FONT></TD><TD><FONT color="#363636">9416</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">9213</FONT></TD><TD><FONT color="#363636">9315</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">12892</FONT></TD><TD><FONT color="#363636">10507</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">12926</FONT></TD><TD><FONT color="#363636">11112</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">12505</FONT></TD><TD><FONT color="#363636">11390</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">12242</FONT></TD><TD><FONT color="#363636">11532</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">12646</FONT></TD><TD><FONT color="#363636">11691</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">12611</FONT></TD><TD><FONT color="#363636">11806</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">12836</FONT></TD><TD><FONT color="#363636">11921</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">13142</FONT></TD><TD><FONT color="#363636">12043</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">13063</FONT></TD><TD><FONT color="#363636">12136</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">N Chicago</FONT></TD><TD><FONT color="#363636">7125</FONT></TD><TD><FONT color="#363636">7125</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">6678</FONT></TD><TD><FONT color="#363636">6902</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">9421</FONT></TD><TD><FONT color="#363636">7741</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">9762</FONT></TD><TD><FONT color="#363636">8247</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">9626</FONT></TD><TD><FONT color="#363636">8522</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">10003</FONT></TD><TD><FONT color="#363636">8769</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">10175</FONT></TD><TD><FONT color="#363636">8970</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">10573</FONT></TD><TD><FONT color="#363636">9170</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">10933</FONT></TD><TD><FONT color="#363636">9366</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">11003</FONT></TD><TD><FONT color="#363636">9530</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">11185</FONT></TD><TD><FONT color="#363636">9680</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">New England</FONT></TD><TD><FONT color="#363636">1955</FONT></TD><TD><FONT color="#363636">1955</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">1951</FONT></TD><TD><FONT color="#363636">1953</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">5340</FONT></TD><TD><FONT color="#363636">3082</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">9316</FONT></TD><TD><FONT color="#363636">4641</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">9163</FONT></TD><TD><FONT color="#363636">5545</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">8782</FONT></TD><TD><FONT color="#363636">6085</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">8737</FONT></TD><TD><FONT color="#363636">6463</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">8704</FONT></TD><TD><FONT color="#363636">6744</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">9635</FONT></TD><TD><FONT color="#363636">7065</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">9768</FONT></TD><TD><FONT color="#363636">7335</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">9493</FONT></TD><TD><FONT color="#363636">7531</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">Northeast</FONT></TD><TD><FONT color="#363636">14954</FONT></TD><TD><FONT color="#363636">14954</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">13808</FONT></TD><TD><FONT color="#363636">14381</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">13685</FONT></TD><TD><FONT color="#363636">14149</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">13542</FONT></TD><TD><FONT color="#363636">13997</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">13230</FONT></TD><TD><FONT color="#363636">13844</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">13244</FONT></TD><TD><FONT color="#363636">13744</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">13690</FONT></TD><TD><FONT color="#363636">13736</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">14626</FONT></TD><TD><FONT color="#363636">13847</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">14917</FONT></TD><TD><FONT color="#363636">13966</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">14710</FONT></TD><TD><FONT color="#363636">14041</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">14682</FONT></TD><TD><FONT color="#363636">14099</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">S Chicago</FONT></TD><TD><FONT color="#363636">7752</FONT></TD><TD><FONT color="#363636">7752</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">7368</FONT></TD><TD><FONT color="#363636">7560</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">20632</FONT></TD><TD><FONT color="#363636">11917</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">20991</FONT></TD><TD><FONT color="#363636">14186</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">20525</FONT></TD><TD><FONT color="#363636">15454</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">20645</FONT></TD><TD><FONT color="#363636">16319</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">21005</FONT></TD><TD><FONT color="#363636">16988</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">20988</FONT></TD><TD><FONT color="#363636">17488</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">21503</FONT></TD><TD><FONT color="#363636">17934</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">22205</FONT></TD><TD><FONT color="#363636">18361</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">22607</FONT></TD><TD><FONT color="#363636">18747</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">South Central</FONT></TD><TD><FONT color="#363636">18372</FONT></TD><TD><FONT color="#363636">18372</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">16762</FONT></TD><TD><FONT color="#363636">17567</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">16209</FONT></TD><TD><FONT color="#363636">17114</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">16049</FONT></TD><TD><FONT color="#363636">16848</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">16786</FONT></TD><TD><FONT color="#363636">16836</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">16844</FONT></TD><TD><FONT color="#363636">16837</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">17597</FONT></TD><TD><FONT color="#363636">16946</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">18086</FONT></TD><TD><FONT color="#363636">17088</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">19141</FONT></TD><TD><FONT color="#363636">17316</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">19061</FONT></TD><TD><FONT color="#363636">17491</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">19908</FONT></TD><TD><FONT color="#363636">17710</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">Southeast</FONT></TD><TD><FONT color="#363636">10388</FONT></TD><TD><FONT color="#363636">10388</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">9393</FONT></TD><TD><FONT color="#363636">9891</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">9456</FONT></TD><TD><FONT color="#363636">9746</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">9394</FONT></TD><TD><FONT color="#363636">9658</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">9358</FONT></TD><TD><FONT color="#363636">9598</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">9989</FONT></TD><TD><FONT color="#363636">9663</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">9860</FONT></TD><TD><FONT color="#363636">9691</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">9925</FONT></TD><TD><FONT color="#363636">9720</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">11208</FONT></TD><TD><FONT color="#363636">9886</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">13442</FONT></TD><TD><FONT color="#363636">10241</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">13523</FONT></TD><TD><FONT color="#363636">10540</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">Western</FONT></TD><TD><FONT color="#363636">12328</FONT></TD><TD><FONT color="#363636">12328</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">11183</FONT></TD><TD><FONT color="#363636">11756</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">11169</FONT></TD><TD><FONT color="#363636">11560</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">11392</FONT></TD><TD><FONT color="#363636">11518</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">11112</FONT></TD><TD><FONT color="#363636">11437</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">11832</FONT></TD><TD><FONT color="#363636">11503</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">11980</FONT></TD><TD><FONT color="#363636">11571</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">13133</FONT></TD><TD><FONT color="#363636">11766</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">13225</FONT></TD><TD><FONT color="#363636">11928</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">13040</FONT></TD><TD><FONT color="#363636">12039</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">12727</FONT></TD><TD><FONT color="#363636">12102</FONT></TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Tue, 29 Jan 2019 13:33:27 GMT tmumaw 2019-01-29T13:33:27Z RangeSum with Average https://community.qlik.com/t5/QlikView/RangeSum-with-Average/m-p/1534576#M439052 <P>Hi All,</P><P>Can someone please tell me if there is a way to calculate a rolling 5 year average using the RangeSum?&nbsp; Here is what I have.</P><P><FONT size="3"><FONT color="#0000ff">rangesum</FONT>(<FONT color="#0000ff">Before</FONT>(<FONT color="#0000ff">Count</FONT>({&lt;<FONT color="#800000">YR_SW</FONT> = {1}&gt;}<FONT color="#0000ff">DISTINCT</FONT>(<FONT color="#800000">[Sold To]</FONT>)),0,5)) </FONT></P><P><FONT size="3">Example of what I have 2013 has 1300 customers so the 2013's average would be 1300, then 2014 has 1200 customer and the rolling total would be 2500 and it's average would be 1250, etc.....</FONT></P><P><FONT size="3">Thanks</FONT></P> Sat, 16 Nov 2024 04:40:15 GMT https://community.qlik.com/t5/QlikView/RangeSum-with-Average/m-p/1534576#M439052 tmumaw 2024-11-16T04:40:15Z Re: RangeSum with Average https://community.qlik.com/t5/QlikView/RangeSum-with-Average/m-p/1534583#M439055 Ignore this post. I figured it out. Thu, 24 Jan 2019 15:25:49 GMT https://community.qlik.com/t5/QlikView/RangeSum-with-Average/m-p/1534583#M439055 tmumaw 2019-01-24T15:25:49Z Re: RangeSum with Average https://community.qlik.com/t5/QlikView/RangeSum-with-Average/m-p/1534584#M439056 <P>May be use RangeAvg() instead of RangeSum()</P><PRE>RangeAvg(Before(Count({&lt;YR_SW = {1}&gt;}DISTINCT([Sold To])),0,5))</PRE> Thu, 24 Jan 2019 15:25:53 GMT https://community.qlik.com/t5/QlikView/RangeSum-with-Average/m-p/1534584#M439056 sunny_talwar 2019-01-24T15:25:53Z Re: RangeSum with Average https://community.qlik.com/t5/QlikView/RangeSum-with-Average/m-p/1534588#M439057 <P>Thanks Sunny I figured it out right after I hit the post button.</P> Thu, 24 Jan 2019 15:27:15 GMT https://community.qlik.com/t5/QlikView/RangeSum-with-Average/m-p/1534588#M439057 tmumaw 2019-01-24T15:27:15Z Re: RangeSum with Average https://community.qlik.com/t5/QlikView/RangeSum-with-Average/m-p/1536527#M439191 <P>Sunny,</P><P>Good morning.&nbsp; I was wondering if there is a way to calculate a % of growth using the RangeSum?&nbsp; What I am trying to do is find % of growth over a 11 year period by year.&nbsp; I'm using this for the RangeAvg.&nbsp; Thanks. The first column is actual and the second if from the statement below.</P><P><FONT size="2"><FONT color="#0000ff">RangeAvg</FONT>(<FONT color="#0000ff">Before</FONT>(<FONT color="#0000ff">Count</FONT>({&lt;<FONT color="#800000">YR_SW</FONT> = {1}&gt;}<FONT color="#0000ff">DISTINCT</FONT>(<FONT color="#800000">[Sold To]</FONT></FONT><FONT size="1"><FONT size="2">)),0,11))</FONT> </FONT></P><TABLE border="1" cellspacing="0" cellpadding="2"><TBODY><TR><TD><FONT color="#363636">Great Lakes Central</FONT></TD><TD><FONT color="#363636">11753</FONT></TD><TD><FONT color="#363636">11753</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">10697</FONT></TD><TD><FONT color="#363636">11225</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">10935</FONT></TD><TD><FONT color="#363636">11128</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">11417</FONT></TD><TD><FONT color="#363636">11201</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">11513</FONT></TD><TD><FONT color="#363636">11263</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">11440</FONT></TD><TD><FONT color="#363636">11293</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">12014</FONT></TD><TD><FONT color="#363636">11396</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">12116</FONT></TD><TD><FONT color="#363636">11486</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">13099</FONT></TD><TD><FONT color="#363636">11665</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">13362</FONT></TD><TD><FONT color="#363636">11835</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">13184</FONT></TD><TD><FONT color="#363636">11957</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">Great Lakes E</FONT></TD><TD><FONT color="#363636">16859</FONT></TD><TD><FONT color="#363636">16859</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">16081</FONT></TD><TD><FONT color="#363636">16470</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">16508</FONT></TD><TD><FONT color="#363636">16483</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">16684</FONT></TD><TD><FONT color="#363636">16533</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">16749</FONT></TD><TD><FONT color="#363636">16576</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">17135</FONT></TD><TD><FONT color="#363636">16669</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">17536</FONT></TD><TD><FONT color="#363636">16793</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">17730</FONT></TD><TD><FONT color="#363636">16910</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">18364</FONT></TD><TD><FONT color="#363636">17072</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">20011</FONT></TD><TD><FONT color="#363636">17366</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">19781</FONT></TD><TD><FONT color="#363636">17585</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">Great Lakes W</FONT></TD><TD><FONT color="#363636">11117</FONT></TD><TD><FONT color="#363636">11117</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">10601</FONT></TD><TD><FONT color="#363636">10859</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">10881</FONT></TD><TD><FONT color="#363636">10866</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">11262</FONT></TD><TD><FONT color="#363636">10965</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">11240</FONT></TD><TD><FONT color="#363636">11020</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">11685</FONT></TD><TD><FONT color="#363636">11131</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">17360</FONT></TD><TD><FONT color="#363636">12021</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">18131</FONT></TD><TD><FONT color="#363636">12785</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">19272</FONT></TD><TD><FONT color="#363636">13505</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">20395</FONT></TD><TD><FONT color="#363636">14194</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">20869</FONT></TD><TD><FONT color="#363636">14801</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">Mid Atlantic</FONT></TD><TD><FONT color="#363636">9416</FONT></TD><TD><FONT color="#363636">9416</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">9213</FONT></TD><TD><FONT color="#363636">9315</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">12892</FONT></TD><TD><FONT color="#363636">10507</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">12926</FONT></TD><TD><FONT color="#363636">11112</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">12505</FONT></TD><TD><FONT color="#363636">11390</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">12242</FONT></TD><TD><FONT color="#363636">11532</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">12646</FONT></TD><TD><FONT color="#363636">11691</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">12611</FONT></TD><TD><FONT color="#363636">11806</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">12836</FONT></TD><TD><FONT color="#363636">11921</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">13142</FONT></TD><TD><FONT color="#363636">12043</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">13063</FONT></TD><TD><FONT color="#363636">12136</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">N Chicago</FONT></TD><TD><FONT color="#363636">7125</FONT></TD><TD><FONT color="#363636">7125</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">6678</FONT></TD><TD><FONT color="#363636">6902</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">9421</FONT></TD><TD><FONT color="#363636">7741</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">9762</FONT></TD><TD><FONT color="#363636">8247</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">9626</FONT></TD><TD><FONT color="#363636">8522</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">10003</FONT></TD><TD><FONT color="#363636">8769</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">10175</FONT></TD><TD><FONT color="#363636">8970</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">10573</FONT></TD><TD><FONT color="#363636">9170</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">10933</FONT></TD><TD><FONT color="#363636">9366</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">11003</FONT></TD><TD><FONT color="#363636">9530</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">11185</FONT></TD><TD><FONT color="#363636">9680</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">New England</FONT></TD><TD><FONT color="#363636">1955</FONT></TD><TD><FONT color="#363636">1955</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">1951</FONT></TD><TD><FONT color="#363636">1953</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">5340</FONT></TD><TD><FONT color="#363636">3082</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">9316</FONT></TD><TD><FONT color="#363636">4641</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">9163</FONT></TD><TD><FONT color="#363636">5545</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">8782</FONT></TD><TD><FONT color="#363636">6085</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">8737</FONT></TD><TD><FONT color="#363636">6463</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">8704</FONT></TD><TD><FONT color="#363636">6744</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">9635</FONT></TD><TD><FONT color="#363636">7065</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">9768</FONT></TD><TD><FONT color="#363636">7335</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">9493</FONT></TD><TD><FONT color="#363636">7531</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">Northeast</FONT></TD><TD><FONT color="#363636">14954</FONT></TD><TD><FONT color="#363636">14954</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">13808</FONT></TD><TD><FONT color="#363636">14381</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">13685</FONT></TD><TD><FONT color="#363636">14149</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">13542</FONT></TD><TD><FONT color="#363636">13997</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">13230</FONT></TD><TD><FONT color="#363636">13844</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">13244</FONT></TD><TD><FONT color="#363636">13744</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">13690</FONT></TD><TD><FONT color="#363636">13736</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">14626</FONT></TD><TD><FONT color="#363636">13847</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">14917</FONT></TD><TD><FONT color="#363636">13966</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">14710</FONT></TD><TD><FONT color="#363636">14041</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">14682</FONT></TD><TD><FONT color="#363636">14099</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">S Chicago</FONT></TD><TD><FONT color="#363636">7752</FONT></TD><TD><FONT color="#363636">7752</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">7368</FONT></TD><TD><FONT color="#363636">7560</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">20632</FONT></TD><TD><FONT color="#363636">11917</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">20991</FONT></TD><TD><FONT color="#363636">14186</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">20525</FONT></TD><TD><FONT color="#363636">15454</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">20645</FONT></TD><TD><FONT color="#363636">16319</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">21005</FONT></TD><TD><FONT color="#363636">16988</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">20988</FONT></TD><TD><FONT color="#363636">17488</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">21503</FONT></TD><TD><FONT color="#363636">17934</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">22205</FONT></TD><TD><FONT color="#363636">18361</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">22607</FONT></TD><TD><FONT color="#363636">18747</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">South Central</FONT></TD><TD><FONT color="#363636">18372</FONT></TD><TD><FONT color="#363636">18372</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">16762</FONT></TD><TD><FONT color="#363636">17567</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">16209</FONT></TD><TD><FONT color="#363636">17114</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">16049</FONT></TD><TD><FONT color="#363636">16848</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">16786</FONT></TD><TD><FONT color="#363636">16836</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">16844</FONT></TD><TD><FONT color="#363636">16837</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">17597</FONT></TD><TD><FONT color="#363636">16946</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">18086</FONT></TD><TD><FONT color="#363636">17088</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">19141</FONT></TD><TD><FONT color="#363636">17316</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">19061</FONT></TD><TD><FONT color="#363636">17491</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">19908</FONT></TD><TD><FONT color="#363636">17710</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">Southeast</FONT></TD><TD><FONT color="#363636">10388</FONT></TD><TD><FONT color="#363636">10388</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">9393</FONT></TD><TD><FONT color="#363636">9891</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">9456</FONT></TD><TD><FONT color="#363636">9746</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">9394</FONT></TD><TD><FONT color="#363636">9658</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">9358</FONT></TD><TD><FONT color="#363636">9598</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">9989</FONT></TD><TD><FONT color="#363636">9663</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">9860</FONT></TD><TD><FONT color="#363636">9691</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">9925</FONT></TD><TD><FONT color="#363636">9720</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">11208</FONT></TD><TD><FONT color="#363636">9886</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">13442</FONT></TD><TD><FONT color="#363636">10241</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">13523</FONT></TD><TD><FONT color="#363636">10540</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">Western</FONT></TD><TD><FONT color="#363636">12328</FONT></TD><TD><FONT color="#363636">12328</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">11183</FONT></TD><TD><FONT color="#363636">11756</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">11169</FONT></TD><TD><FONT color="#363636">11560</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">11392</FONT></TD><TD><FONT color="#363636">11518</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">11112</FONT></TD><TD><FONT color="#363636">11437</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">11832</FONT></TD><TD><FONT color="#363636">11503</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">11980</FONT></TD><TD><FONT color="#363636">11571</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">13133</FONT></TD><TD><FONT color="#363636">11766</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">13225</FONT></TD><TD><FONT color="#363636">11928</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">13040</FONT></TD><TD><FONT color="#363636">12039</FONT></TD><TD>&nbsp;</TD><TD><FONT color="#363636">12727</FONT></TD><TD><FONT color="#363636">12102</FONT></TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Tue, 29 Jan 2019 13:33:27 GMT https://community.qlik.com/t5/QlikView/RangeSum-with-Average/m-p/1536527#M439191 tmumaw 2019-01-29T13:33:27Z