Forum Discussion
Summarize Table with different Filters for each column
Hi all,
I created a new table to summarize my data. I am doing totals for each individual.
I applied the filters needed for the first column, however I want to add other columns with different filters (especially different date filters).
Looking at the picture, my table is summarizing for each player, my 2 first columns "Microcycle HSR" and "Microcycle Total Distance" were date filtered by
ThomasRichard , You can move the filter to Summarize for each expression
Example
"M1", calculate(sum(Table[Value]), filter(Table, Table[Period Name] in {"P1", "P2"} && Table[Col] = "A"))
Prefer in over OR
2 Replies
- amitchandakSuper User
ThomasRichard , You can move the filter to Summarize for each expression
Example
"M1", calculate(sum(Table[Value]), filter(Table, Table[Period Name] in {"P1", "P2"} && Table[Col] = "A"))
Prefer in over OR
- ThomasRichardHelper I
amitchandak Thank you very much, it seems to be working this way!