Exclude blank/null from straight table

[#1]

I have a data set with a column for Name_of_Covered_Drug and a column for the Total_Spend associated to that drug. There is some spend reported that is not associated to a drug so the Name_of_Covered_Drug can be blank. I want a table showing top 10 drugs by spend  but my table keeps including a single bar grouping all the blank drug names. I tried "Suppress when value is null" in Dimensions and I also tried the expression of

Sum ({$<Name_of_Covered_Drug-={NULL}>}Total_Spend)

also Sum ({$<Name_of_Covered_Drug={"*"}>} Total_Spend)

Any advice on how to type expression so that it will give me Total Spend only when a drug name is present(excluding nulls)?

Thanks

[sunny_talwar · Accepted solution]

Can you try this as your dimension:

If(Len(Trim(Name_of_Covered_Drug)) > 0, Name_of_Covered_Drug)

and now select 'Suppress When Value Is Null' on the dimensions tab

[#3]

Perfect! Thank you