3 Replies Latest reply: Oct 26, 2012 2:41 PM by whiteline _ RSS

    Collapse Table

      Hi Experts,

       

      I have a table with Sales Order Positions, and i have a flag if the position is in Delay or not.

       

      Order     Pos     Delay

      991          10     1

      991          20     0

      991          30     0

      888          10     0

      888          20     0

      888          30     0

       

       

      I should have a chart with the Sales Order without Position, and,if at least one position is 1, all Order is 1.

      if all order is 0 the Order Record is 0.

       

       

      Order     Delay

      991          1

      888          0

       

      Can you help me ?

        • Re: Collapse Table

          The solution is near.

           

          every Order Can has several position in Delay.

           

          Order     Pos     Delay

          991          10     1

          991          20     1

          991          30     0

          888          10     0

          888          20     0

          888          30     0

          666          10     1

          666          20     1

          666          30     1   

           

           

          But in my chart I want only e chart that gives me only a flag. For examble

          Order     Delay

          991          1

          888          0

          666          0

            • Re: Collapse Table

              Errata Corrige

               

              But in my chart I want only e chart that gives me only a flag. For examble

              Order     Delay

              991          1

              888          0

              666          1

              • Re: Collapse Table
                whiteline _

                Order     Pos     Delay

                991          10     1

                991          20     1

                991          30     0

                888          10     0

                888          20     0

                888          30     0

                666          10     1

                666          20     1

                666          30     1

                 

                Hi.

                Don't understand how have you got 1 for 991 'cause there are both 0 and 1.

                 

                You could create collapsed table in script with group by statement (look at help).

                You could also just create a 'table box' with two fields  Order and Delay.