Skip to Content
0
Former Member
Jan 22, 2009 at 03:55 PM

Disappearing columns due to filters/no data

129 Views

Hi all,

I'm trying to create a report with several sheets with accounts across the top and various brand groupings as my rows.

The problem is that I need my column list to remain consistent for each sheet but when I filter on the brand groupings (rows) if an account doesn't have any sales for that grouping the filter eliminates the account from showing up in my output.

Hopefully this is a quick fix.

Thanks!

Thomas

Edited by: Thomas Guy on Jan 22, 2009 4:56 PM