I have a table that has AcctNum, AcctName, and ParentAcctNum in it. I need to set up a hiearchy for it in a pivot table along with a hiearchy filter. There are 4 top level parent accounts, however the level for each varies from 2-6 total levels depending on the parent acct. I'm getting more than a few null values that I can't seem to get rid of, if I uncheck Show Null Values, then once I expand past the max level for a parent account it disappears. I have also tried unchecking the Show Zero Values box also. I also need to get rid of all the nulls from each level. I'm currently using the Hiearchy function with defaults. Thanks in advance for any help or advice!
