ASP.NET, SQL Server, WPF, C#, VB.NET

We have a sales target measure with monthly sales goals for each sales rep  
  
(from a table with rows for each salesrep per month).  The table is  
  
populated with values for the entire year (12 months).  
  
We have a monlthy sales measure that aggregates the sales for each salesrep  
  
by month.  
  
We have a KPI that identifies sales by month for each sales rep (from sales  
  
by month measure) with the target set to the sales goal measure.  When you  
  
filter the KPI on the current year, the goal value is the sum for the entire  
  
year, while the sales values only exist to the current month (June).  So the  
  
threshold is wrong and is showing a score (indicator) that is far below the  
  
target.  
  
How do we make it so the target only includes values for the months that  
  
have currently passed (exclude future months values from the total)?  
  
Thanks!

You may use MDX formula.  A sample would be:  
  
For current period:  
  
([Measures].[Gross Profit], [Date].[Fiscal Year].LastChild)  
  
For previous period:  
  
([Measures].[Gross Profit],[Date].[Fiscal Year].LastChild.Lag(1))  
  
There are some sample MDX in FoodMart and AdventureWorks workspace files.  
  
--  
  
Thanks,  
  
Tony Li [MSFT]  
  
This posting is provided "AS IS" with no warranties, and confers no rights.  
  
"Steven" <steven.heinz@ilg.com> wrote in message  
  
news:%23uiJpSnhGHA.4284@TK2MSFTNGP05.phx.gbl...