Line chart

[stephenedberkg]

in line chart i used below expression

=Sum({<Year={$(=Max(Year))},MonthID= {$(=Max(MonthID))},Year=,Month=>} Aggr(If(Only({1}MonthIDS) = Max(TOTAL <ID> MonthID ) + Only(TOTAL <ID> OrderLockPeriod)  ,

Sum({<Year={$(=Max(Year))},MonthID= {$(=Max(MonthID))},Year=,Month=>}sales)), ID, MonthIDS ))

if i selected the month sep it displaying only the sep month values.

but i want to show all month till sep.

help me?

Ragards

Stephen G

[Anonymous]

Use Date Filterration for same?

Like, Year Start Date till Max Date Selected

[stephenedberkg]

could you please write it in the above expression?

[Anonymous]

Did you check these?

YTQ, QTD, MTD and WTD

Set Analysis for certain Point in Time

Clean explanation for same

[effinty2112]

Hi Stephen,

                    It looks to me that the set modifier MonthID= {$(=Max(MonthID))} is preventing you seeing months prior to Sep when Sep is selected try replacing that with something like

MonthID = {"<=$(=Max(MonthID))"}

Good luck.

[stephenedberkg]

Dear Effinty2112

already i tried like that but i can't get it.