rkaif wrote:Please see the attached screen-shot of the sample Period dimension.
Hope this helps~!
Rizwan, thanks for the screen shot. in this picture, is YTD2002 a sum of YTD200201, YTD200202, ...? If yes, then doesn't it have 200201 more than one time?
I think where I am struggling is more on the reporting side. Is there a way to have such a dimension where YTD is automatically calculated based on the current month that we are in (system date)?
YTD -> This is an automatic calculation. based on the current month it is a total of YTD months.