topic Totals through formulas for different levels in QlikView https://community.qlik.com/t5/QlikView/Totals-through-formulas-for-different-levels/m-p/888684#M309681 <HTML><HEAD></HEAD><BODY><P>Good day!</P><P></P><P>Really need your help.</P><P>I should to find the correct approximation formula.</P><P>I have three levels of measurements i<SPAN style="font-size: 13.3333330154419px;">n my report.</SPAN></P><P>The formula is calculated as follows: VolumeMTD / Number of past working days MTD* Number of working days in all for this month, where MTD - month to date.</P><P>My formula works correctly only for the lower level because the number of past working days and total number of working days are loaded in the system only for the lower level.</P><P><SPAN style="font-size: 13.3333330154419px;">For next level formula sums working days but it's not correct in my case.</SPAN></P><P>An example of a report in the attachment.</P><P><IMG alt="2015-05-19_171608.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/86899_2015-05-19_171608.jpg" style="height: 238px; width: 620px;" /></P><P>HELP! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 19 May 2015 14:24:33 GMT Anonymous 2015-05-19T14:24:33Z Totals through formulas for different levels https://community.qlik.com/t5/QlikView/Totals-through-formulas-for-different-levels/m-p/888684#M309681 <HTML><HEAD></HEAD><BODY><P>Good day!</P><P></P><P>Really need your help.</P><P>I should to find the correct approximation formula.</P><P>I have three levels of measurements i<SPAN style="font-size: 13.3333330154419px;">n my report.</SPAN></P><P>The formula is calculated as follows: VolumeMTD / Number of past working days MTD* Number of working days in all for this month, where MTD - month to date.</P><P>My formula works correctly only for the lower level because the number of past working days and total number of working days are loaded in the system only for the lower level.</P><P><SPAN style="font-size: 13.3333330154419px;">For next level formula sums working days but it's not correct in my case.</SPAN></P><P>An example of a report in the attachment.</P><P><IMG alt="2015-05-19_171608.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/86899_2015-05-19_171608.jpg" style="height: 238px; width: 620px;" /></P><P>HELP! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 19 May 2015 14:24:33 GMT https://community.qlik.com/t5/QlikView/Totals-through-formulas-for-different-levels/m-p/888684#M309681 Anonymous 2015-05-19T14:24:33Z Re: Totals through formulas for different levels https://community.qlik.com/t5/QlikView/Totals-through-formulas-for-different-levels/m-p/888685#M309682 <HTML><HEAD></HEAD><BODY><P>Have you tried creating a pivot table and enabling the Partial Sums options for the relevant dimensions?</P></BODY></HTML> Wed, 20 May 2015 12:40:13 GMT https://community.qlik.com/t5/QlikView/Totals-through-formulas-for-different-levels/m-p/888685#M309682 Gysbert_Wassenaar 2015-05-20T12:40:13Z