Forum Discussion
Solved
Adding a Column Filter to my current formula
Good morning all! I'm trying to modify my current formula to filter results by a column value if it matches another table's column. My example dataset is attached, but here's the goal: Table1 ...
keltzjd I used the file you sent earlier. Seems to work as expected. See Attached.
I agree, but I've already built a dashboard that has this filter across 20 or so sheets, so I'm kind of stuck with using this formula lol. Do you know how to achieve it using my current formula? Thanks!
keltzjd I guess you can expand it with with one more rule. I.e. multiply by an array where the Zone in table2 agrees to the zone in table1. Similar to what you have now for finding matching names.
- This is what my formula looks like with that addition but it's not working, where am I getting it wrong?
=SUM(
MMULT(
--(Table57[[PM]:[CM5]] = Table27[@[Name]:[Name]] ),
SEQUENCE( COLUMNS( Table57[[PM]:[CM5]] ), , 1,0) ) *
(Table57[Zone] = Table27[@[Zone]:[Zone]] ),
SEQUENCE( COLUMNS( Table57[Zone] ), , 1,0) ) *
Table57[[SUM]:[SUM]] *
( Table57[[Start Date]:[Start Date]] <=
DATEVALUE(Table27[[#Headers],[1/1/2022]] )
) *
( Table57[[End Date]:[End Date]] >=
DATEVALUE(Table27[[#Headers],[1/1/2022]] )
)
)keltzjd I used the file you sent earlier. Seems to work as expected. See Attached.
- It did! Thank you so much!