Hi!
Ok so not sure how to clearly explain this.
Looking to be able to filter or sort or both a report by account. I have the rows grouped as columns B/C/D/E/F/G is just account info but ROWS 7-12 have all the data which starts in Col H and onward. My issue is that when I go to select one ACCT # and then ungroup it shows the data rows of the other accounts. I just want it to show that account.
I tried to merge the rows in column B/C/D/E/F but it's not working either.
I want to option to see overall at acct level, un-groupped to show division data or by specific account.
Hope my screen shots will help.
Thx
Bookmarks