Hi All,
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).
Thanks.
Regards,
Yojas
