I have 2 nested rows, Department and Account, in my accounts I want to show 2 accounts, whether they're 0 or not. It sounds from the help that Suppress=B: should work, but it doesn't seem to be working. I can't put Retain(Account1,Account2) as that gives me an error. Has anyone found an easier workaround that doesn't involve hiding or adding rows back manually within Excel? I see 2 other requests of this in the forum, but no good answers.
Thanks.