topic Running Subtotals in QlikView https://community.qlik.com/t5/QlikView/Running-Subtotals/m-p/839393#M531592 <HTML><HEAD></HEAD><BODY><P>OK. I have been trying for 2 weeks to come up with a solution for this scenario. I have bruised my head enough an am now ready for some help. If you have any to offer, I will gladly accept it. I have attached a QVW of my basic pivot table and a XLS file with the way I would like it to look. Please note that there are 4 dimensions with the last one being horizontal. Where I want the running subtotal is on the 3rd dimension. I have come close by using RangeSum with Before and After an Above and Below. But I can not get what I need. I can not figure out how to get a running subtotal that resets after a particular dimension.</P><P></P><P>I have a feeling this is probably going to turn out to be much easier than I think, but I can't see it.</P><P></P><P>Thanks for any help.</P></BODY></HTML> Fri, 05 Jun 2015 19:45:40 GMT 2015-06-05T19:45:40Z Running Subtotals https://community.qlik.com/t5/QlikView/Running-Subtotals/m-p/839393#M531592 <HTML><HEAD></HEAD><BODY><P>OK. I have been trying for 2 weeks to come up with a solution for this scenario. I have bruised my head enough an am now ready for some help. If you have any to offer, I will gladly accept it. I have attached a QVW of my basic pivot table and a XLS file with the way I would like it to look. Please note that there are 4 dimensions with the last one being horizontal. Where I want the running subtotal is on the 3rd dimension. I have come close by using RangeSum with Before and After an Above and Below. But I can not get what I need. I can not figure out how to get a running subtotal that resets after a particular dimension.</P><P></P><P>I have a feeling this is probably going to turn out to be much easier than I think, but I can't see it.</P><P></P><P>Thanks for any help.</P></BODY></HTML> Fri, 05 Jun 2015 19:45:40 GMT https://community.qlik.com/t5/QlikView/Running-Subtotals/m-p/839393#M531592 2015-06-05T19:45:40Z Re: Running Subtotals https://community.qlik.com/t5/QlikView/Running-Subtotals/m-p/839394#M531593 <HTML><HEAD></HEAD><BODY><P>Please check if fits your needs</P></BODY></HTML> Fri, 05 Jun 2015 20:32:44 GMT https://community.qlik.com/t5/QlikView/Running-Subtotals/m-p/839394#M531593 Clever_Anjos 2015-06-05T20:32:44Z Re: Running Subtotals https://community.qlik.com/t5/QlikView/Running-Subtotals/m-p/839395#M531594 <HTML><HEAD></HEAD><BODY><P>Clever. Thank you very much. I had looked at something similar to this, but now I understand how it works. Wayne</P></BODY></HTML> Fri, 05 Jun 2015 20:45:41 GMT https://community.qlik.com/t5/QlikView/Running-Subtotals/m-p/839395#M531594 2015-06-05T20:45:41Z Re: Running Subtotals https://community.qlik.com/t5/QlikView/Running-Subtotals/m-p/839396#M531595 <HTML><HEAD></HEAD><BODY><P>I´ve added a dummy dimension to create that line 'Running' and then you check with dimentionality() if you are in that line</P></BODY></HTML> Fri, 05 Jun 2015 20:51:59 GMT https://community.qlik.com/t5/QlikView/Running-Subtotals/m-p/839396#M531595 Clever_Anjos 2015-06-05T20:51:59Z