Calculating Growth Rate with Applied Time Period Filters

[SebastianVI]

Hi all,

I have a dataset with sales by product across different stores and divisions in the U.S., covering the last 2 years on a weekly basis. When I apply time period filters (e.g., the last 4 weeks), I want to calculate the sales growth rate for that specific period. The challenge arises when trying to calculate the sales for the corresponding period in the previous year and there are time periods filters on. 

Here is the formula I’ve been using—it works well, but once I include the item level in the calculation, it stops working. Any help would be greatly appreciated!

Thanks!

LastYearSales=Sum({1<Date={">=$(=(MinDate_LY))<=$(=(MaxDate_LY))"},

    Division=p(Division),

    Store_number=p(Store_number),

    Item_category=p(Item_category),

    Item=p(Item)  

>} DOLLARS)