I am running a matrix for sales on last 3 years and attached a forcast for current year.
now then i try and create a % to forcast since its a martix it adds up all 3 years. I have the years broken up by SDYEAR how can i make an expression that just uses year 2012
i think i have the logic.. just not sure how to wright it
=Fields!Sales.Value(where SDyear =201)/Fields!Forcastsalesm