Not affect by a single filter

[eddywong71]

Hi All,

I have create a set analysis to show the latest 30 day of record under below

sum([$<[Datee]={">=$(=max([Datee])-30)<=$(=max([.Datee]|)"),[Product]={'car'),[Month ]=>} [Total Amount])

I want the chart not affect by the Month. Because i create a filter let the user choose the month.The set analysis should affect by other filter except Month.

Can anyone help.

[Timario]

Hi. I take your expression and make some changes. Try it 
sum({< [Datee] ={">=$(=date(max([Datee])-30))<=$(=max(Datee) )"}, Product={'car'}, [Month] >} [Total Amount] )

[eddywong71]

Hi Timario, i try this expression. However, the last 30 day still change base on the month selection. I want the last 30 day is fix no matter what the month choosing and is the latest.

[Timario]

sum({<Datee, [Month], [Datee] ={">=$(=date(max([Datee])-30))<=$(=max(Datee) )"}, Product={'car'} >} [Total Amount] )

Other words, try write in set analysis variables which shouldn't affect on measure