target

[dnowebdn]

Hi Team,

Please refer to my source and sample app and provide me the solution.

[dnowebdn]

Someone please respond me.

[OmarBenSalem]

Do u have a date field?

[OmarBenSalem]

If u do not have a date field :

create a variable :

call it : vMaxMonth

as follow:

=date(max(date(Date#( MonthStart( date#(Month,'MMM')) ,'M/D/YYYY'),'DD/MM')),'DD/MM')

1)

Then, change ur measure from:

sum(Sales) to

Sum({<Month={"=date(Date#(MonthStart(date#(Month,'MMM')),'M/D/YYYY'),'DD/MM')='$(vMaxMonth)'"}>}Sales)

Result:

[OmarBenSalem]

and btwn, things will be SO MUCH EASIER if u have a date field

[dnowebdn]

Thanks and can you please suggest me on the second chart - line chart to get the data till the values we select i.e if we select feb -- data should be Jan, Feb should appear.

[OmarBenSalem · Accepted solution]

U know what, Create a date field in ur script:

date( (date(Date#( MonthStart( date#(Month,'MMM')) ,'D/M/YYYY'),'DD/MM')&'/'&Year),'DD/MM/YYYY')  as Date,

Now expressions would be SO MUCJ EASIER:

1) Sum({<Date={"$(=max(Date))"}>}Sales)

2) Sum({<Month, Date={"<=$(=max(Date))"}>}Sales)

[dnowebdn]

Thanks but I have month values in capital and may i know where to use that capitalize function

[OmarBenSalem]

I can't follow u? Didn't I respond to ur quest? What capitalize function?