How to exclude a value in dimension's field

[#1]

Hi,

i want to exclude one value in the field i'm using as dimension could you please help me about that?

i want to display Motor without '28 inch' for example.

[awhitfield · Accepted solution]

Hi abdallah,

one way is to replace the list box dimension with an expression e.g.

if(Motor <> '28 Inch', Motor)

Andy

[jagan]

Hi,

You can achieve this using Calculation Dimension like below

If(Motor <> '28 Inch', Motor)

If you are doing this in chart you can exclude this in Set analysis expression

=Sum({<Motor -= {'28 Inch'}>} Sales)

Hope this helps you.

Regards,

Jagan.

[patroser]

If you want to avoid both "28 Inch"'s you could transform the value within the conditional check.

if(lower(Motor) <> '28 inch', Motor)

in this case don't forget to write 28 inch in lower case

Patrick

[Peter_Cammaert]

Maybe it's better to add some applymap() translation to your script so that different spellings all map to the same Dimension value?

[Peter_Cammaert]

Or a simple ...CAPITALIZE(Motor) AS Motor, ... in your script may already do wonders...

[buzzy996]

try this, use expression instituted of field in ur list box.