Filter Pane: How to apply to every column on a table?

[patriciousa]

Hi community experts. I'll appreaciate your help to solve something for me.

I have a Filter Pane and a Table on my sheet.

"Deuda Clientes" is my filter pane.

I need it to ONLY and ONLY apply to an specific column on the table.

Not sure if it is important but that specific column has this expression:

"sum(aggr(if(TODAY(2)>(BLDAT+ZBD1T), Sum({<"SHKZG"={S},"ZLSCH"-={"J"}>} DMBTR)

-Sum({<"SHKZG"={H},"ZLSCH"-={"J"}>} DMBTR)), BUKRS, KUNNR, NAME1, XBLNR))"

Thank you in advance.

Regards.

[sunny_talwar]

It might be, but my only concern is that it might not behave well with selections. Would you be able to share the file you are working with?

[patriciousa]

Sure!!

First sheet, "TOTAL VENCIDO" column is the one I want to be filtered by top filter pane.

Thank you.

Regards.

[sunny_talwar]

Check out my failed attempt to do this. I think the best course of action would be to create this in the script

[patriciousa]

Still, if I have to create it in the script, how?