Previous six month data without set amalysis

[Anonymous]

Hi All,

i have a date(mmm yy) dimension coming from master calendar table. Currently it is showing all the date in the chart i.e from jan 2015 to current date.

Month yr, Amount

Jan 15,10000

feb 15, 20000

MAr 15,30000

.

.

.

.

AUg 16, 220000.

now when i select particular month from calendar lets say jul 16 the chart should show only prev six month i.e

feb 16,111111

mar 16,22222

apr 16,333333

may 16,444444

jun 16, 555655

july 16,666666

looking for solution with out set analysis. Any help would be appreciated. Thanks

[arusanah]

create two variables as

varBeginDate= Date(MonthStart(Max([Date])),'MM/DD/YYYY')

varEndDate=Date(addmonths(MonthStart(Max([Date])),-6),'MM/DD/YYYY')

expression should go like :

Count( {<[Date]={">$(varBeginDate)<=$(varBeginDate)"} <field that you are counting >)

[Anonymous]

Hi manoj,

If you dont use Set Analisys your calendar must be separated from the other tables, because you will select only one month, and you will show only one month.

Regards.