Set Analysis should Ignore only Year??

[#1]

Hello Experts,

I have the below expression

Sum({< TIME_PERIOD_START_DATE = {'>=$(=AddYears(Today(), -1))<=$(=Date(Today()))'}, FORECAST_TYPE = {'Q0F'} >} FCT_GROSS_REVENUE) / 1000

This expression shows the current - 52 weeks data on a chart at anytime and works exactly the way I wanted, however I want this to change only when I select a Product or a Customer dimension and not the year.. any wayt to do it.
I know if we add (1{< ignores the selections, but again it does it for all...

Thanks in Advance,
ANDY

[Miguel_Angel_Baeyens · Accepted solution]

Hi Andy,

Although I've answered in your previous post, I'll do here as well. Your expression if my assumption is correct, should look like the following

Sum({< Year =, TIME_PERIOD_START_DATE = {'>=$(=AddYears(Today(), -1))<=$(=Date(Today()))'}, FORECAST_TYPE = {'Q0F'} >} FCT_GROSS_REVENUE) / 1000

Where Year is the field you want to select and its selection be ignored by the expression.

Hope that helps.