Hello All,
Below is the table which I have created and I need to hide the vendor numbers which have null values in Amount column.
Currently I am hiding it manually but I want to hide it using calculated field so that my auto refresh on extract works and I don't need to open the work book to manually hide these rows.
Regards,
Chandrakanth.K
Aug 14, 2018 8:25 AM
hi Chandrakanth
So one way is to create a formula like this
[Amount NULL]
ZN([Amountinloccurr2])=0
or you could use ISNULL
You can then bring this in and hide the True values. As you are hiding true and not actual vendors, it will be dynamic to any NULL values.
Hope that helps and makes sense.
Hi,
You can filter without creating any calculated field.
Just drag the Amount measure in filters shelf and select special values and choose non-null values
Let us know if this help.
Mahfooj
Hello Mahfooj Khan,
How did I miss this simple trick. Thank you for you inputs and this worked.
Regards,
Chandrakanth.K
Hello Simon,
Thank you for your inputs. This also helped.
Regards,
Chandrakanth.K
I guess sometimes it happens with all of us
Aug 16, 2018 1:06 AM
No problem...it all depends if you want to "hide" or "filter". To "hide" you'd use my method, and for Filtering Mahfooj's is the easiest (you could also use my method, and bring the True/False onto the filter shelf...but why add the extra calculation when you don't need to!!)