Calculated Dimension to change the Dimension Labels?
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.
