Expression to only show unmapped fields

[khaycock]

I need an expression that removes all of the categories that have values but only shows the unmapped ones at the bottom for another table! Is it even possible?

So I really only want to see the 939 values, nothing else.

Thanks!

[sunny_talwar]

May be change the Category dimensions to this

If(Len(Trim(Category)) = 0, 1, 0)

and then check 'Suppress When Value Is Null' on the dimensions tab

[vishsaggi]

What is your current expression? may be like

Dim: Category, Month

Expr:

= Sum({<Category = {"= Len(Trim(Category)) = 0"} >}Val)

Created some sample and got below is this what you are looking for?

[khaycock]

I changed the 1 to unmapped (and reloaded the data so there is now 1089 not 939) but what do I do about the 114 mapped to 0?

I also have suppressed the dimension when null and it didn't go..

[khaycock]

Using this expression (with my appropriate field names) returned these results:

sum({<CATEGORY= {"= Len(Trim(CATEGORY)) = 0"} >}SHIPPED_QUANTITY)

[sunny_talwar · Accepted solution]

My bad... should be this

If(Len(Trim(Category)) = 0, 'Unmapped')

[vishsaggi]

Did you suppress 0 values in your Presentation tab? And if possible can you share your sample file. Did you try Sunny's updated expr?