Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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?
Sure!!
First sheet, "TOTAL VENCIDO" column is the one I want to be filtered by top filter pane.
Thank you.
Regards.
Check out my failed attempt to do this. I think the best course of action would be to create this in the script
Still, if I have to create it in the script, how?