How to Exclude a single value in a dimension for a particular report ?

[ramcena306]

Hello All,

i have a multibox and it is a linked object, and i want to exclude particular value in a dimension in that multibox in a single report.

any suggestions ?

Thanks & Best Regards,

Ramesh

[shiveshsingh]

May be this?

=if(Month <> 'Jan',Month)

Like i have excluded Jan in Month Dimension.

[ramcena306]

Hello Shivesh,

Thanks for your replay, 

i want to exclude the value from this field when the sheet is activated.

Regards,

Ramesh.

[shiveshsingh]

Hello Ramcena

Do one thing, create one variable and set it's value to 0.

Now create a trigger which set variable value to 1 on sheet activation and also create a trigger that resets it's value to 0 again on sheet leave.

Now you can set a conditional dimension like

=if(vTest=1,if(Company<>'C1',Company))

Hope this helps.