topic Re: How To sum continues accumulating amount in column in App Development https://community.qlik.com/t5/App-Development/How-To-sum-continues-accumulating-amount-in-column/m-p/1593412#M63113 <TABLE border="1"><TBODY><TR><TD>Year</TD><TD>Jan</TD><TD>feb</TD><TD>march</TD><TD>apr</TD><TD>may</TD><TD>jun</TD><TD>july</TD><TD>aug</TD><TD>etc</TD></TR><TR><TD>2013</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR><TR><TD>2014</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR><TR><TD>2015</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR><TR><TD>2016</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>lets assume all are 1</P> Wed, 19 Jun 2019 08:13:35 GMT Step 2019-06-19T08:13:35Z How To sum continues accumulating amount in column https://community.qlik.com/t5/App-Development/How-To-sum-continues-accumulating-amount-in-column/m-p/1593361#M63110 <P>I would like it to be like this in pivot table;</P><P>Year,Month,amount</P><TABLE border="1"><TBODY><TR><TD>Year</TD><TD>jan</TD><TD>feb</TD><TD>march</TD><TD>april</TD><TD>may&nbsp;</TD><TD>jun</TD><TD>july</TD><TD>aug</TD><TD>etc</TD></TR><TR><TD>2013</TD><TD>1</TD><TD>2</TD><TD>3</TD><TD>4</TD><TD>5</TD><TD>6</TD><TD>7</TD><TD>8</TD><TD>9</TD></TR><TR><TD>2014</TD><TD>10</TD><TD>11</TD><TD>12</TD><TD>13</TD><TD>14</TD><TD>15</TD><TD>16</TD><TD>17</TD><TD>18</TD></TR><TR><TD>2015</TD><TD>19</TD><TD>20</TD><TD>21</TD><TD>22</TD><TD>23</TD><TD>24</TD><TD>25</TD><TD>26</TD><TD>27</TD></TR><TR><TD>2016</TD><TD>28</TD><TD>29</TD><TD>30</TD><TD>31</TD><TD>32</TD><TD>33</TD><TD>34</TD><TD>35</TD><TD>36</TD></TR><TR><TD>2017</TD><TD>37</TD><TD>38</TD><TD>39</TD><TD>40</TD><TD>41</TD><TD>42</TD><TD>43</TD><TD>44</TD><TD>45</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>instead i got this:</P><P>I used this expression&nbsp;RangeSum(Before(Sum(Amount), 0, ColumnNo()))</P><TABLE border="1"><TBODY><TR><TD>year</TD><TD>jan</TD><TD>feb</TD><TD>march</TD><TD>april</TD><TD>may&nbsp;</TD><TD>jun</TD><TD>july</TD><TD>aug</TD><TD>etc</TD></TR><TR><TD>2013</TD><TD>1</TD><TD>2</TD><TD>3</TD><TD>4</TD><TD>5</TD><TD>6</TD><TD>7</TD><TD>8</TD><TD>9</TD></TR><TR><TD>2014</TD><TD>1</TD><TD>2</TD><TD>3</TD><TD>4</TD><TD>5</TD><TD>6</TD><TD>7</TD><TD>8</TD><TD>9</TD></TR><TR><TD>2015</TD><TD>1</TD><TD>2</TD><TD>3</TD><TD>4</TD><TD>5</TD><TD>6</TD><TD>7</TD><TD>8</TD><TD>9</TD></TR><TR><TD>2016</TD><TD>1</TD><TD>2</TD><TD>3</TD><TD>4</TD><TD>5</TD><TD>6</TD><TD>7</TD><TD>8</TD><TD>9</TD></TR></TBODY></TABLE> Fri, 02 Apr 2021 07:58:29 GMT https://community.qlik.com/t5/App-Development/How-To-sum-continues-accumulating-amount-in-column/m-p/1593361#M63110 Step 2021-04-02T07:58:29Z Re: How To sum continues accumulating amount in column https://community.qlik.com/t5/App-Development/How-To-sum-continues-accumulating-amount-in-column/m-p/1593394#M63111 <P>How is your input data set?</P> Wed, 19 Jun 2019 07:32:02 GMT https://community.qlik.com/t5/App-Development/How-To-sum-continues-accumulating-amount-in-column/m-p/1593394#M63111 Anil_Babu_Samineni 2019-06-19T07:32:02Z Re: How To sum continues accumulating amount in column https://community.qlik.com/t5/App-Development/How-To-sum-continues-accumulating-amount-in-column/m-p/1593410#M63112 <P>assume all are 1, i just add them up per column</P> Thu, 20 Jun 2019 03:06:49 GMT https://community.qlik.com/t5/App-Development/How-To-sum-continues-accumulating-amount-in-column/m-p/1593410#M63112 Step 2019-06-20T03:06:49Z Re: How To sum continues accumulating amount in column https://community.qlik.com/t5/App-Development/How-To-sum-continues-accumulating-amount-in-column/m-p/1593412#M63113 <TABLE border="1"><TBODY><TR><TD>Year</TD><TD>Jan</TD><TD>feb</TD><TD>march</TD><TD>apr</TD><TD>may</TD><TD>jun</TD><TD>july</TD><TD>aug</TD><TD>etc</TD></TR><TR><TD>2013</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR><TR><TD>2014</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR><TR><TD>2015</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR><TR><TD>2016</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>lets assume all are 1</P> Wed, 19 Jun 2019 08:13:35 GMT https://community.qlik.com/t5/App-Development/How-To-sum-continues-accumulating-amount-in-column/m-p/1593412#M63113 Step 2019-06-19T08:13:35Z