https://communities.sas.com/t5/SAS-Visual-Analytics/CumulativePeriod-aggregation-can-t-get-this-to-filter-properly/m-p/826400#M16291 <P>Hi I have a cumulative period aggregation. When I create an action from a dropdown box to a key value or a table to get the cumulative Month to date this works well. Also if i just a filter directly for a date it works. What i really want is not to have the dropdown but control the filter form the data. I have created a variable that is the date I want and otherwise missing. This does not give me the cumulative aggregation but the days value.</P><P>&nbsp;</P><P>Do anybody have an idea why this should not work.</P><P>&nbsp;</P><P>Pål N&nbsp;</P> Mon, 01 Aug 2022 07:05:16 GMT PaalNavestad 2022-08-01T07:05:16Z https://communities.sas.com/t5/SAS-Visual-Analytics/CumulativePeriod-aggregation-can-t-get-this-to-filter-properly/m-p/826400#M16291 <P>Hi I have a cumulative period aggregation. When I create an action from a dropdown box to a key value or a table to get the cumulative Month to date this works well. Also if i just a filter directly for a date it works. What i really want is not to have the dropdown but control the filter form the data. I have created a variable that is the date I want and otherwise missing. This does not give me the cumulative aggregation but the days value.</P><P>&nbsp;</P><P>Do anybody have an idea why this should not work.</P><P>&nbsp;</P><P>Pål N&nbsp;</P> Mon, 01 Aug 2022 07:05:16 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/CumulativePeriod-aggregation-can-t-get-this-to-filter-properly/m-p/826400#M16291 PaalNavestad 2022-08-01T07:05:16Z