How to break dynamic expression with aggr from interacting with a filter

[RenewalBIUser]

Hello,

I'm trying to get this formula to not move when a RevenueRecognizedDate is selected, but it keeps changing.  Any ideas?

sum({1<EventType = {'Order','Change Order'}, Work_Order_Type__c = {'Install'}, IsOrderCancelled = {0}, RollingMonthFlag={1}, IsWorkOrderStatusCancelled={0}, RevenueRecognizedDate =>} Total_Labor_Cost__c)/

Aggr(NoDistinct sum({1<EventType = {'Order','Change Order'}, IsOrderCancelled = {0}, IsItemCancelled = {0}, RollingMonthFlag={1}, RevenueRecognizedDate =>} Total_Retail_Price__c),"Month and Year")

[kaushiknsolanki]

Try this.

Aggr({<RevenueRecognizedDate =>}NoDistinct sum({1<EventType = {'Order','Change Order'}, IsOrderCancelled = {0}, IsItemCancelled = {0}, RollingMonthFlag={1}, RevenueRecognizedDate =>} Total_Retail_Price__c),"Month and Year")

[RenewalBIUser]

Thanks for the suggestion, however, it still filters down to the RevenueRecognizedDate range selected using that set analysis.