HI,
I am showing report like below and am passing prompt values current month and current week.
MTD AND YTD Values are calculated at repository level by using todate time series function.
I have time dimension with below levels.
Financial year,Quarter,Month,week and Day.
At year,quarter,month and day level all values are coming currect.
only week level YTD Values are coming wrong.
Pleaase let me know the reason.
| FRANCHISE | CURRENCY | FOR THE PERIOD | FOR THE MONTH | YEAR TO DATE |
| | | Dec-15 | 2015 / 2016 |
| NO. OF | VALUE | NO. OF | VALUE | NO. OF | VALUE |
| UNITS | UNITS | UNITS |
| MMC VEHICLES | KD | | | | | | |
| FUSO VEHICLES | KD | | | | | | |
| HEAVY VEHICLES | KD | | | | | | |
| ZINGER VEHICLES | KD | | | | | | |
| SEM VEHICLES | KD | | | | | | |
| JAC / FOTON VEHICLES | KD | | | | | | |
| USED CARS | KD | | | | | | |
Regards,
MIT.