Hi
I have a Cube with Store / Product / Date/Sales Type etc.
I need to provide a measure within the cube that shows me sales value last year if there is a sale this year.
The store dimension as attributes such as Area and Region and I need to make sure when browsing by Area etc if a Store did not have sales this year then the sales for Last Year are not included, even though there could be other stores within that Area that has Sales.
I also need to be able to have the measure filterable that when a user selects a specific store the grand totals will filter down accordingly.
Many Thanks
Dan