Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

HELP: Matrix Column Subtotals Type different Summarization Type from Values

Hi Community,  Is there a way to change the type for matrix subtotals ?  Let me explain the issue I have. Imagine I have two tables entities: entity   country   value a UK 5 b USA ...
matrix
subtotals
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Anonymous 
    Here is the updated solution as per your requirement https://www.dropbox.com/t/4TYzPYWvbgrSkooo

    Count = 
IF ( 
    ISINSCOPE (entities[entity] ),
    DISTINCTCOUNT ( relationships[investor] ),
    DISTINCTCOUNT (  relationships[entity] )
)
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Sadly your solution has exactly the same issue I have. The total for investor X is 1, altough it should be 2 (investor X has a grant relationship with a and with c, so 2 in total) . Any idea how to solve that?