YTD Current Ratio Table it is possible to convert to Current Ration Trend line.

[paulyeo11]

Hi All

I have a Current ratio Table 1 which give me correct result. as below :-

March 2013 Current Ratio = 50.55% ( when month = 3 & year = 2013

Feb 2013 Current Ratio = 47.62% ( when month = 2 & year = 2013

The issue is of the above table it only allow to show me Current Ratio for one period.  Now my aim is view the trend line of Current Ratio By MonthYear. what i did is i add YearMonth field at diamension. and it does able to plot the trend line of current ratio. But the result is not correct.

Hope some one can advise me how to do it.

Paul

[paulyeo11]

Can some one with very powerful on aggr or advise me ?