Set analysis syntax errore

[#1]

Hi,

How to Hide Selected Field in Set analysis code and how to remove null in script level while loding .

Thanks.

[swuehl · Accepted solution]

Use only one set modifier per field:

Sum({$<Shipping_Status-={'Rejected','Hold'} >}Revenue)  

[swuehl]

And for filtering status in the LOAD, something like

LOAD (Shipping_Status) as Shipping_Status,

     (Country) as Country  ,

     (Areacode) as Areacode ,

    (Payment_Mode) as Payment_Mode,

(Revenue) as Revenue

FROM

(ooxml, embedded labels, table is Sheet1)

WHERE (Shipping_Status) <> 'NULL';