Hi All,

I'm in process of designing a cube for a KPI that will show comparison
of values based on weeks e.g.
- Current Week
- Last Week
- Trend

The value for week to be calulated is %Accuracy i.e.
- Current Week = 90%
- Last Week = 93%
- Trend = -ve

The data i'm getting is count of accurate and non-accurate based on
Year to Date (YTD).

Can anyone tell me how to calculate the trend, rolling the YTD value
till the said week i.e. current and last? What to store in the time
dimension and how?

Yes I'm new to this!

Any help will be highly appreciated.