Hierarchy with null values in one of the fields

[vishalmanu]

Hi,

I have a table with the fields Company, Country, State, City and the State fields have Null Values. So please let me know how to create a Hierarchy. And also please let me know it If the State field will be displayed once the Hierarchy is executed.