custom x-axis, script or calculated dimension?

[#1]

Hi, I'm looking to create a custom axis for my chart and was wondering if anyone has any ideas?

Basically the x-axis should show Q1, Q2, Q3, Q4 of last year, and at the end of the axis it should also have the month selected of this year.  I'm really not sure how to go about this.  Any help would be much appreciated.

thanks in advance

[#2]

it is a pretty freak:P idea but:

makew an iland table :

LOAD * INLINE [

    dimension

    q1

    q2

    q2

    q2

    actualmonth

];

paste dimension as your dimension and make an expression such as: if (dimension =q1, "set analysis", if(....))

[#3]

Hi,

If the yaxis is sales (say in a bar chart), you can create 5 expressions with setanalysis. Name the expressions as Q1,Q2,..,CurrentMonth

That would do it.

Kiran.