3 Replies Latest reply: Jun 2, 2017 11:42 AM by RANJIT KAKADE RSS

    Need Help In Expression

    RANJIT KAKADE

      Dear Expert,

       

       

       

       

              I have Following  Inline Table

       

       

      Test:

      Load * Inline [

      Type,Sp,ExchangeCoe,Month

      P,100,NSE,Jan

      SP,200,BSE,Jan

      P,300,BSE,Feb

      SP,500,NSE,Feb

      SP,600,BSE,Mar

      ];

       

      after adding fields into table it showing like Sample.png

       

      Please Find Actual and Expected images.

       

      Here My Requirement is when i click on Type  SP  it is showing sales   500,200,600

       

      like that if i click on Type  P i want to show  300,100,600

       

      Note: if i click on Type P i want to Show 300,100 for Feb,Jan and

      For March Month i want show 600

       

      logic is if i click on Type P want to show sales 300,100, for March Month There is no Type P in this Case i want Show SP Sales As P Sales

       

       

       

       

       

      Please Kindly Help Me

       

      Thanks,

      K.Ranjit.

       

       

      stalwar1reddys310jaganstephanejanin