My question is about the useage of a KPI status icon in excel 2007.
I have created a KPI in SSAS which will calculate the difference of two measure which is Actual FH FC ratio and Average FH FC Ratio..
These two measures combined with the KPI value AND the Date dimension gives only those records back for that fact and Date. IN this examples it will return from the year 2006 thry 2009 facts (DimDate is from 19300101 thru 20301231) and this is what i want and get in excel. again the status of this KPI is unchecked from the PivotTable Field list.