I have a PivotTable I am trying to use as a Chart of Accounts to display parents and children of accounts. I have multiple levels and come to a point where I have empty (blank) cells that are in the Pivot Data. In the PivotTable, I need the (Blank) not to appear. Has anyone figured out a way to basically hide any rows that show blank cells?
Sorry, I can't figure out how to add an attachment.
Sorry, I can't figure out how to add an attachment.