Date Dimension Limited to Possible Only

[Anonymous]

In my chart, I have two dimensions: Customer and Quarter

I want to only show the calendar's possible Quarters based on the max date. Primarily because without doing this my expression shows a row/column of 0's because of no data.....because it is in the future.

So how do you exclude future dates if your dimension is

For example:

Year = 2012

Today = 08/09/2012

Possible dates = everything before 'today'

Month = August

Possible months = everything from August to January (January representing the lowest possible month given the max year of 2012)

Quarter = 3

Possible quarters = 1, 2, and 3 -----> not 4 because the highest date has determined it hasn't happened yet

[MayilVahanan · Accepted solution]

Hi

     Try like this,

     = if you have date field,

     =Sum({<DateField = {'>=$(=MonthStart(Min(DateField)))<=$(=Date(Today()))'}>}Sales)

     Hope it helps