Forum Discussion
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 ...
Hi Anonymous
Here is the updated solution as per your requirement https://www.dropbox.com/t/4TYzPYWvbgrSkoooCount = IF ( ISINSCOPE (entities[entity] ), DISTINCTCOUNT ( relationships[investor] ), DISTINCTCOUNT ( relationships[entity] ) )
tamerj1
Community Champion
Community ChampionHi Anonymous
Which one is the correct result you are looking for?
This
| investor | entity a | entity c | COLUMN SUBTOTAL |
| X | 1 | 2 | 2 |
| Y | 1 | 1 |
Or this
| investor | entity a | entity c | COLUMN SUBTOTAL |
| X | 1 | 1 | 1 |
| Y | 1 | 1 |