4 Replies Latest reply: Jul 28, 2014 3:38 AM by Bhawna Gupta RSS

    Expression Drill

      Hello Everyone,

      I have a line chart based on various project.The issue is to first show a single line of total by month,and as the Total line selected then the all projects line should be displayed. I am not able to understand how to do this.

      Lets suppose I have following table

      ProjectMonthValue
      P1Apr20
      P2Apr30
      P3Apr40
      P1May10
      P2May50
      P3May20
      P1Jun30
      P2Jun50
      P3Jun10
      P1Jul20
      P2Jul30
      P3Jul30

       

      And the ouput must following chart like1.png

      and as I select this total line following Chart should be display

      2.png

      please anyone have any idea share with me.

      Thanks

      Bhawna