YTD Current Ratio Table it is possible to convert to Current Ration Trend line.
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.