6 Replies Latest reply: Jul 18, 2013 1:58 AM by Parthiban Durairaj RSS

    Separated line charts for one selection

      Hi All,

       

      I have done up 2 line charts, where one shows all the currency types and another one showing the line chart for USD.

      I want to make sure that the USD line chart remains fixed no matter what currency i choose from my listbox for the other chart.

      This is so that I can compare the two currency charts, eg. AUD and USD, MYR and USD etc etc

       

      I tried detaching the USD chart but once I save and exit, the detach property will disappear when I open it up again, which is troublesome.

      Is there any way that I can change my in expression for the USD chart to remain fixed?

       

      Below is my expression for the USD chart. I used two dimensions, tenor and date of reporting.

       

      Sum(

           {1<Curr_Type={'USD'}>}

           Rate_Exp

           )

       

      Below is my expression for the charts will currency types.

       

      Sum(Rate_Exp)

       

      I already tried modifying my 1 with $, remove quote ' ' but it still does not work..

       

      Any suggestions?