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] )
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
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

    Thank you very much - this has been bothering me for quite some time.