https://communities.sas.com/t5/SAS-Visual-Analytics/periodic-cumulative-measure-does-not-respond-as-expected/m-p/768730#M15301 <P>I want to aggregate for the upcoming next 12 months, so the calendar year shouldn't impact at all.</P> <P>My first choice was the periodic cumulative measure but I cannot sum over the next 12 months. This goes against my understanding what this measure promises to do.</P> <P>My workaround is to sum relative periods (0 to 11 by 1). This works but feels complicated.</P> <P>&nbsp;</P> <P>Here comes the code for the aggregated measure outlook 12 months that fulfills the task.&nbsp;</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">CumulativePeriod(_Sum_, 'Frequency'n, _IgnoreAllTimeFrameFilters_ , '_FECULVTO'n, _ByMonth_, _ByMonth_, 1, 1, _Full_, {Date}) + CumulativePeriod(_Sum_, 'Frequency'n, _IgnoreAllTimeFrameFilters_ , '_FECULVTO'n, _ByMonth_, _ByMonth_, 2, 1, _Full_, {Date}) + CumulativePeriod(_Sum_, 'Frequency'n, _IgnoreAllTimeFrameFilters_ , '_FECULVTO'n, _ByMonth_, _ByMonth_, 3, 1, _Full_, {Date}) + CumulativePeriod(_Sum_, 'Frequency'n, _IgnoreAllTimeFrameFilters_ , '_FECULVTO'n, _ByMonth_, _ByMonth_, 4, 1, _Full_, {Date}) + CumulativePeriod(_Sum_, 'Frequency'n, _IgnoreAllTimeFrameFilters_ , '_FECULVTO'n, _ByMonth_, _ByMonth_, 5, 1, _Full_, {Date}) + CumulativePeriod(_Sum_, 'Frequency'n, _IgnoreAllTimeFrameFilters_ , '_FECULVTO'n, _ByMonth_, _ByMonth_, 6, 1, _Full_, {Date}) + CumulativePeriod(_Sum_, 'Frequency'n, _IgnoreAllTimeFrameFilters_ , '_FECULVTO'n, _ByMonth_, _ByMonth_, 7, 1, _Full_, {Date}) + CumulativePeriod(_Sum_, 'Frequency'n, _IgnoreAllTimeFrameFilters_ , '_FECULVTO'n, _ByMonth_, _ByMonth_, 8, 1, _Full_, {Date}) + CumulativePeriod(_Sum_, 'Frequency'n, _IgnoreAllTimeFrameFilters_ , '_FECULVTO'n, _ByMonth_, _ByMonth_, 9, 1, _Full_, {Date}) + CumulativePeriod(_Sum_, 'Frequency'n, _IgnoreAllTimeFrameFilters_ , '_FECULVTO'n, _ByMonth_, _ByMonth_, 10, 1, _Full_, {Date}) + CumulativePeriod(_Sum_, 'Frequency'n, _IgnoreAllTimeFrameFilters_ , '_FECULVTO'n, _ByMonth_, _ByMonth_, 11, 1, _Full_, {Date}) + CumulativePeriod(_Sum_, 'Frequency'n, _IgnoreAllTimeFrameFilters_ , '_FECULVTO'n, _ByMonth_, _ByMonth_, 0, 1, _Full_, {Date}) </CODE></PRE> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="cross.png" style="width: 999px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/63760i9002E2C1A9E02B36/image-size/large?v=v2&amp;px=999" role="button" title="cross.png" alt="cross.png" /></span></P> Tue, 21 Sep 2021 10:25:11 GMT acordes 2021-09-21T10:25:11Z https://communities.sas.com/t5/SAS-Visual-Analytics/periodic-cumulative-measure-does-not-respond-as-expected/m-p/768730#M15301 <P>I want to aggregate for the upcoming next 12 months, so the calendar year shouldn't impact at all.</P> <P>My first choice was the periodic cumulative measure but I cannot sum over the next 12 months. This goes against my understanding what this measure promises to do.</P> <P>My workaround is to sum relative periods (0 to 11 by 1). This works but feels complicated.</P> <P>&nbsp;</P> <P>Here comes the code for the aggregated measure outlook 12 months that fulfills the task.&nbsp;</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">CumulativePeriod(_Sum_, 'Frequency'n, _IgnoreAllTimeFrameFilters_ , '_FECULVTO'n, _ByMonth_, _ByMonth_, 1, 1, _Full_, {Date}) + CumulativePeriod(_Sum_, 'Frequency'n, _IgnoreAllTimeFrameFilters_ , '_FECULVTO'n, _ByMonth_, _ByMonth_, 2, 1, _Full_, {Date}) + CumulativePeriod(_Sum_, 'Frequency'n, _IgnoreAllTimeFrameFilters_ , '_FECULVTO'n, _ByMonth_, _ByMonth_, 3, 1, _Full_, {Date}) + CumulativePeriod(_Sum_, 'Frequency'n, _IgnoreAllTimeFrameFilters_ , '_FECULVTO'n, _ByMonth_, _ByMonth_, 4, 1, _Full_, {Date}) + CumulativePeriod(_Sum_, 'Frequency'n, _IgnoreAllTimeFrameFilters_ , '_FECULVTO'n, _ByMonth_, _ByMonth_, 5, 1, _Full_, {Date}) + CumulativePeriod(_Sum_, 'Frequency'n, _IgnoreAllTimeFrameFilters_ , '_FECULVTO'n, _ByMonth_, _ByMonth_, 6, 1, _Full_, {Date}) + CumulativePeriod(_Sum_, 'Frequency'n, _IgnoreAllTimeFrameFilters_ , '_FECULVTO'n, _ByMonth_, _ByMonth_, 7, 1, _Full_, {Date}) + CumulativePeriod(_Sum_, 'Frequency'n, _IgnoreAllTimeFrameFilters_ , '_FECULVTO'n, _ByMonth_, _ByMonth_, 8, 1, _Full_, {Date}) + CumulativePeriod(_Sum_, 'Frequency'n, _IgnoreAllTimeFrameFilters_ , '_FECULVTO'n, _ByMonth_, _ByMonth_, 9, 1, _Full_, {Date}) + CumulativePeriod(_Sum_, 'Frequency'n, _IgnoreAllTimeFrameFilters_ , '_FECULVTO'n, _ByMonth_, _ByMonth_, 10, 1, _Full_, {Date}) + CumulativePeriod(_Sum_, 'Frequency'n, _IgnoreAllTimeFrameFilters_ , '_FECULVTO'n, _ByMonth_, _ByMonth_, 11, 1, _Full_, {Date}) + CumulativePeriod(_Sum_, 'Frequency'n, _IgnoreAllTimeFrameFilters_ , '_FECULVTO'n, _ByMonth_, _ByMonth_, 0, 1, _Full_, {Date}) </CODE></PRE> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="cross.png" style="width: 999px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/63760i9002E2C1A9E02B36/image-size/large?v=v2&amp;px=999" role="button" title="cross.png" alt="cross.png" /></span></P> Tue, 21 Sep 2021 10:25:11 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/periodic-cumulative-measure-does-not-respond-as-expected/m-p/768730#M15301 acordes 2021-09-21T10:25:11Z