Im creating a sales report in SSRS by pointing it at a cube in SSAS. Im creating calculated members to aggregate my data in various ways so they can be shown on the report.
I have a FACT table containing sales figures and various dimension tables including a server created time dimension.
Ive managed to create pretty much everthing I need (e.g. Current YTD, Prior year YTD). What I now need is a full year figure to compare current year sales to.
Below is what Im aiming for i.e. the total of 122712 from 2009 appearing against every month in 2010.
Full Prior Year sales
Ive been bashing my head against a brick wall with this one so any help would be gratefully received!
View Complete Post