It sounds like you could use 1 parameter (which selects Latest 12 weeks or Latest 4 weeks).
Then, I think you would be able to create "conditional" measures for 2012 data and 2011 data (using something like IF YEAR([DateField]) = 2012/2011 THEN ... ELSE NULL END) and then create your % change, and other measures based on the new "conditional" measures.
Can you post your workbook? or at least a screen shot?
We need to know what fields you have in your data.
Thanks Mark....I am attaching a test workbook for your reference. The issue is my Latest X weeks and L X weeks year ago are already aggregate based on my raw data.
I tried hiding 2011 but when I change from one time period to another, because all 2011 are hidden it does not give me the calculations of % chg, etc
Sheet 2 is the look I am looking for. I dont want the empty column that is shown in Sheet 1 and want to make it easier for the user not to have to pick 2 time frames - I am afraid that can cause errors if they choose a 52 wk 2012 vs 24 wk 2011 by mistake.
Thanks again for your help!
TEST.twbx.zip 18.4 KB
I have attached your workbook with what I understand to be the solution you're after.
You essentially want to choose the "period" portion of the [TIME] field i.e., L4W, L12W, L24W, L52W or YTD and then compare the value from 2011 to the value in 2012.
I created the 2 conditional measures [2011 Dollars] and [2012 Dollars] that I alluded to. But it looks like we didn't need a parameter. Rather, I created an extra calculated field that extracted the "period" portion of the [TIME] field.
Let me know if that is not what you're after.
test.twbx.zip 18.6 KB
That's exactly what I was looking for!!!! Thank you Mark...really appreciate the help!!!