It sounds like it could be a permission problem? When you click through from the "state level", you have other permissions than when you arrive first at the "city level".
Or you are not filtering at the right level? See the attached workbook in the article below:
Hope this can get you started, -Birgit