https://community.qlik.com/t5/App-Development/Cumulative-Measure-with-Calendar-Drill-Down-Dimension/m-p/1999009#M82745 <P>Hello Team,</P> <P>I am using below expression to get cumulative user count and getting correct values for cumulation. And in dimension I have created Calendar drill down with Month, Week and Day fields. So this cumulative value gives correct value for Month field with proper sorting of Months but sorting order changes when drill down with Week and Day field. Is there any solution?</P> <P>See below images:</P> <P>Img1:&nbsp; All months data</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Prathamesh_Bait_0-1667302493994.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/92595iBC360252C0727E9E/image-size/medium?v=v2&amp;px=400" role="button" title="Prathamesh_Bait_0-1667302493994.png" alt="Prathamesh_Bait_0-1667302493994.png" /></span></P> <P>&nbsp;</P> <P>Img2: Drill down in August 22 month</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Prathamesh_Bait_1-1667302605353.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/92597i360144395D46E593/image-size/medium?v=v2&amp;px=400" role="button" title="Prathamesh_Bait_1-1667302605353.png" alt="Prathamesh_Bait_1-1667302605353.png" /></span></P> <P>&nbsp;</P> Tue, 01 Nov 2022 11:36:21 GMT Prathamesh_Bait 2022-11-01T11:36:21Z https://community.qlik.com/t5/App-Development/Cumulative-Measure-with-Calendar-Drill-Down-Dimension/m-p/1999009#M82745 <P>Hello Team,</P> <P>I am using below expression to get cumulative user count and getting correct values for cumulation. And in dimension I have created Calendar drill down with Month, Week and Day fields. So this cumulative value gives correct value for Month field with proper sorting of Months but sorting order changes when drill down with Week and Day field. Is there any solution?</P> <P>See below images:</P> <P>Img1:&nbsp; All months data</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Prathamesh_Bait_0-1667302493994.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/92595iBC360252C0727E9E/image-size/medium?v=v2&amp;px=400" role="button" title="Prathamesh_Bait_0-1667302493994.png" alt="Prathamesh_Bait_0-1667302493994.png" /></span></P> <P>&nbsp;</P> <P>Img2: Drill down in August 22 month</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Prathamesh_Bait_1-1667302605353.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/92597i360144395D46E593/image-size/medium?v=v2&amp;px=400" role="button" title="Prathamesh_Bait_1-1667302605353.png" alt="Prathamesh_Bait_1-1667302605353.png" /></span></P> <P>&nbsp;</P> Tue, 01 Nov 2022 11:36:21 GMT https://community.qlik.com/t5/App-Development/Cumulative-Measure-with-Calendar-Drill-Down-Dimension/m-p/1999009#M82745 Prathamesh_Bait 2022-11-01T11:36:21Z