Hi, Kevin

If you'd like to keep the detail of the weekly metrics, it'll dice it by week. You may try level of detail calculation - if you can post a sample workbook, I'll try demonstrating creating the calculated field.

-Mia-

Hi Kevin,

Mia's right- level of detail calculations will solve this problem.  We can use LODs to calculate our number of records to the week level and then author our KPI calculation.

First, we'll need to create a new date part for just the week.  Right click on your date dimension, and select create-->custom date.  For this we'll select the date value of week numbers.

Now we can use this date part in our LOD expression.

{FIXED [Order Date (Week numbers)]: SUM([Number of Records])}

That gets us the number of records at the week level, and we can reference that calc in our KPI.

IF [Number of Records per Week] >= 45 THEN "High"

ELSEIF [Number of Records per Week] >= 25 THEN "Medium"

ELSE "Low"

END

If you want to see just one number for overall percentage of your groupings, you'll have to take the week field off of detail.  Hopefully that's okay, since we're already using the week count as part of the calculation.

Cheers!