4 Replies Latest reply: Sep 20, 2016 3:06 AM by Digvijay Singh RSS

    how to calculate

    x mg

      Hi,

         Everyone, I got a question. the script is as follows:

      t:

      LOAD * INLINE [

           Level2, Sales

          B, 3

          A, 7

          B, 4

          A, 2

      ];

       

      LOAD * INLINE [

          Level1

          A

          B

          C

      ];

       

       

      Now I have a question, I choose Level1='A', how to make the chart like bellow:

       

      That means Level2 only appear the value where Level2 = Level1

       

       

      So, how could I change the expression?