Multiple selection button

[crusader_]

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

[#2]

Just go to the presentation tab and check "Supress Zero Values" and supress missing values.

[crusader_]

Dear Deepak,

Thanks for your response, but I need exactly a button which "Supress Zero Values" and turns back.

Is it possible to make such Action on Button object?

Andrei

[tresesco]

Create two charts one with supression enabled and another without. Then use a button to hide/unhide chart.

PFA

[jagan · Accepted solution]

Hi,

Please find attached file for solution.  Created additional expression and hidden in the table.

Regards,

Jagan.

[crusader_]

Thanks a lot!

That's exactly what I wanted!

[crusader_]

Nice solution!

Thanks for help!