Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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?
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..
Using this expression (with my appropriate field names) returned these results:
sum({<CATEGORY= {"= Len(Trim(CATEGORY)) = 0"} >}SHIPPED_QUANTITY)
My bad... should be this
If(Len(Trim(Category)) = 0, 'Unmapped')
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?