I’m working on a date-to-date comparison. I made a report with day of the week on the X-axis and pivoted three weeks on the Y-axis. Now this works great only to make this more readable, I want to rename the three different weeks to This week, Last week, Last year.
In this example I could off course do this simply by adding something like ‘2015-01-26: Last year’ in the Series Labels field under Style. The problem is, these labels will change every week, so it is not a sustainable solution.
Is there any way to for example always rename the first, second and third series to something, without really mentioning the actual current series name?