Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How to Hide Selected Field in Set analysis code and how to remove null in script level while loding .
Thanks.
Use only one set modifier per field:
Sum({$<Shipping_Status-={'Rejected','Hold'} >}Revenue)
Use only one set modifier per field:
Sum({$<Shipping_Status-={'Rejected','Hold'} >}Revenue)
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';