Filter Multiple Tables and show all results

[NWPhotoExplorer]

I have a table for every month (JANUARY thru DECEMBER). All of these tables are the same. I am trying to figure out how to write a formula that will find certain criteria and display it from every table if there are any matching records. I wrote something that seems to only display information from 1 table and doesn't seem to continue to the next table. I am not sure what I need to add to this.

=IFERROR(FILTER(FILTER(tbl_OFS_JANUARY[[Date]:[Total Billing]],tbl_OFS_JANUARY[Billing Issue]="Y"),{1,1,1,0,0,0,0,0,0,1,0,0,0,1},""),
IFERROR(FILTER(FILTER(tbl_OFS_FEBRUARY[[Date]:[Total Billing]],tbl_OFS_FEBRUARY[Billing Issue]="Y"),{1,1,1,0,0,0,0,0,0,1,0,0,0,1},""),""))

I have a field (Billing Issue) that we put a "Y" in if we can't bill for it. I want to be able to display all these records from every month in 1 filtered section on my sheet. But if January has an issue, it doesn't pull anything from February. Once January jobs have been corrected and billed, then it will show jobs from February. Is this not possible to show everything in the same filtered section?

Thanks in advance!

 

[Fluff]

Are all the tables on the same sheet or different sheets?

 

[NWPhotoExplorer]

Are all the tables on the same sheet or different sheets?

Different sheets. Each is named the month.

 

[Fluff]

Ok, which column is the Billing Issue in relation to the Date column?

 

[NWPhotoExplorer]

Ok, which column is the Billing Issue in relation to the Date column?

It's 6 columns to the right.

Submitted	Date	Job Number	Task Type	SR Number	Total Line Items	Billing	Billing Issue
	1/3/2022					NO

 

[Fluff]

Ok, how about like

=LET(Jan,tbl_OFS_JANUARY[[Date]:[Total Billing]],Feb,tbl_OFS_FEBRUARY[[Date]:[Total Billing]],Mar,tbl_OFS_MARCH[[Date]:[Total Billing]],Janr,ROWS(Jan),Febr,ROWS(Feb)+Janr, Marr,ROWS(Mar)+Febr,s,SEQUENCE(Marr),a,IF(s<=Janr,INDEX(Jan,s,{1,2,3,7,10,14}),IF(s<=Febr,INDEX(Feb, s-Janr,{1,2,3,7,10,14}),INDEX(Mar,s-Febr,{1,2,3,7,10,14}))),FILTER(FILTER(a,INDEX(a,,4)="Y",""),{1,1,1,0,1,1}))

 

[NWPhotoExplorer]

Ok, how about like

=LET(Jan,tbl_OFS_JANUARY[[Date]:[Total Billing]],Feb,tbl_OFS_FEBRUARY[[Date]:[Total Billing]],Mar,tbl_OFS_MARCH[[Date]:[Total Billing]],Janr,ROWS(Jan),Febr,ROWS(Feb)+Janr, Marr,ROWS(Mar)+Febr,s,SEQUENCE(Marr),a,IF(s<=Janr,INDEX(Jan,s,{1,2,3,7,10,14}),IF(s<=Febr,INDEX(Feb, s-Janr,{1,2,3,7,10,14}),INDEX(Mar,s-Febr,{1,2,3,7,10,14}))),FILTER(FILTER(a,INDEX(a,,4)="Y",""),{1,1,1,0,1,1}))

Can you explain this a little? I'm trying to understand how it works, but right now, its just giving me the #VALUE! error. So I can't figure out what isn't working.

 

[Fluff]

Do you have any rows on those 3 tables with a Y under Billing Issues?

 

[NWPhotoExplorer]

Do you have any rows on those 3 tables with a Y under Billing Issues?

Yes I do. I have a row on each of the tables. (January, February and March)

 

[Fluff]

Maybe it's looking at the wrong column, if you try this

=LET(Jan,tbl_OFS_JANUARY[[Date]:[Total Billing]],Feb,tbl_OFS_FEBRUARY[[Date]:[Total Billing]],Mar,tbl_OFS_MARCH[[Date]:[Total Billing]],Janr,ROWS(Jan),Febr,ROWS(Feb)+Janr, Marr,ROWS(Mar)+Febr,s,SEQUENCE(Marr),a,IF(s<=Janr,INDEX(Jan,s,{1,2,3,7,10,14}),IF(s<=Febr,INDEX(Feb, s-Janr,{1,2,3,7,10,14}),INDEX(Mar,s-Febr,{1,2,3,7,10,14}))),f,FILTER(FILTER(a,INDEX(a,,4)="Y",""),{1,1,1,0,1,1}),a)

do you get all rows from those 3 tables & are the "Y"s in the 4th column?