Calculated Dimension to change the Dimension Labels?

[#1]

I want to look at a year over year trend chart (a line chart in this case) by week.  I want the chart to look at the trends by [Week No], but I want to display the [Week] dates by the current year dates.  Can I do this using a cacluated dimension?  I have tried a few caclulations, but have not gotten anything to work.  I am new to the developer side of QV and haven't really used cacluated dimensions yet.  Does anyone have any suggestions?  Any help would be appreciated.

Thank you!

[mike_garcia]

Hi,

I guess yes, a calculated dimension will do the trick... Try looking into the Dual function.

Mike.