Thanks to this forum I have been able to create calculated member formulas that break out TY Sales and LY Sales into two distinct columns. The formulas I used are shown below.
TY Sales = ([Time_LWPA].Currentmember, [Measures].[Dollars Sold])
LY Sales = ([Time_LWPA].Previousmember, [Measures].[Dollars Sold])
My time dimension is:
My problem is that whenever a specific month, week, etc. is selected, the columns still show sales for the entire year.
What is wrong with my formula?