Show next 21 month sales

[stephenedberkg]

if i select the 2013  jan mean i want to show next 21 month sales values in line chart

[jpenuliar]

You will have a Start Date and End Date:

Example: StartDate = Today()

               EndDate = Month(AddMonths(Today(),21))

[jpenuliar]

If you save your Date range in variables, your expression can be:

=Sum({<Date_Field = {'>=$(=date($(vStartDate)))<=$(=date($(vEndDate)))'}>}Sales)

[stephenedberkg]

Thank you for your reply

i want this calculation in dimension. i have master calender  also

[jpenuliar]

you can use your Date Range to a "Select in Field" action, making it visible in your current selection box, or you can use it for your calculated Dimension.

[jpenuliar]

Maybe something like below for your calculated dimension

=if(Date >= vStart_Date and Date <= vEnd_Date,Date)

[stephenedberkg]

Dear Jonathan Penulier,

i want to show the next 21 month from current month.can i change is it in script?

[jpenuliar]

in the load Script? of course you can,

add a Where clause on your Date field with your Date range.

[stephenedberkg]

can you tell that syntax of this

[jpenuliar]

When you say Current month,  you mean this month correct? so I am thinking, what data can you load from your source for the next 21 months?

You see my logic there, how can you load for example the next 21 months transactions if it hasn't happen yet?