Forum Discussion
xliu1
6 years agoHelper II
Conditional sum calculation based on two filters
I try to create a new measure which does the sum based on two conditions: COURSE_FTE_SCH is the table name, [Term],[Course_Level] and [Fundable_SCH ]are the columns within this table. How could I com...
Anonymous
6 years agoNot applicable
xliu1
6 years agoHelper II
Hi Anonymous , no. I am still figuring why your formula works but when I put it to Values it returned blank results.
I have a matrix visualization with TERMID on Rows, Modality on Columns and FTE on Values. I have Term as a filer on this page. 201508/201608... are TERMIDs grouped under Term which includes Spring, Summer, Fall. what I like to achieve is something like this matrix table