I need to create a calculated dimension that has four members. The first will be the current date, the second will be the last day of the same month last year, the third will be the last day of the same month in current year minus 2 and the last will be last day of same month in current year minus 3. Thus the members will look like :
20/03/2013,
31/03/2012
31/03/2011
31/03/2010
I then want to plot these against expressions in a straight table. I will be very grateful if you can share some ideas on this.
