Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
is it possible to share similar data