6 Replies Latest reply: Jan 21, 2014 6:15 AM by Andrei Kaliahin RSS

    Multiple selection button

    Andrei Kaliahin

      Hi,

       

      I have a Chart as a pivot table, which has 3 dimesnions and several expressions. The result of expressions 1 or 0 only.

      Looks like below:

       

      Dim1      Dim2      Dim3      Exp1      Exp2     Exp3     Exp4

      Order1    Name1    Cargo1        0           0            1          0

      Order1    Name1    Cargo2        0           1            0          0

      Order1    Name2    Cargo3        0           0            0          0

      Order2    Name1    Cargo4        1           0            1          0

      Order3    Name1    Cargo5        0           0            0          0

      Order3    Name2    Cargo6        0           0            0          1


      I need to make a button which select all row which contains at least one "1".

      The result should be:

      Dim1      Dim2      Dim3      Exp1      Exp2     Exp3     Exp4

      Order1    Name1    Cargo1        0           0            1          0

      Order1    Name1    Cargo2        0           1            0          0

      Order2    Name1    Cargo4        1           0            1          0

      Order3    Name2    Cargo6        0           0            0          1


      Thanks in advance for help.

      Regards,

      Andrei