My Expression is : Sum({<Date = {">=$(=v_CompDt)<=$(=vWeekToDate)"}>} TOTAL_UNITS_SOLD)
where ::
1) v_CompDt is the date when the Actual Sales happen [Date(Max(num(Date)),'DD/MM/YYYY')].
2) vWeekToDate is a calendar variable which user can select from drop down.
So my o/p for TOTAL_UNITS_SOLD should come in the range of (v_CompDt to vWeekToDate) .
To Display I am using Pivot Chart with Dimensions, Country,Location.
Country
Location
COMP_DATE
Expression
INDONESIA
LOCATION1
10/08/2014
12100(this should come from 10/08/14-1 0/11/14(vWeekToDt) but currently its taking 19/10/15 (as v_CompDt = max(Date), its taking max among all n leading to wrong info)-10/11/14.
INDONESIA
LOCATION2
12/08/2014
18000
INDONESIA
LOCATION3
19/10/2015
26200
Anyone knows how to resolve this problem?? Even I tried using AGGR but it's not working out for me. it (v_CompDt) always takes max(Date).
