We have a report with Design Rows for a Income Statement that some expenses are defined by cost center and account number. Others are strictly on the account number and we’re using a basic filter for that but an advanced filter with cost center and account combination.
We have a sheet repeater to have an income statement for each cost center. For cost centers that have a row with no data it is suppressing those rows where we have the advanced filter. On the basic filter lines we have the “all” checked.
We want to do the same with the advanced filtered lines also, because we will in Excel create a summary tab to add all the cost center tabs together. The issue is the lines in each tab don’t match 1 for 1 because some tabs have rows suppressed and they have difference rows suppressed compared to each other.
how can we get all rows, regardless if a NULL value in each repeated tab for the lines using an advanced filter?
