Forum Discussion
nasolme
Helper I
Helper IIsinscope
Hi Community,
I have a PROJET table related with a CONTRAT table which is related to my TRANCHE table.
1 Projet = many Contrat = 1 contrat = many tranche
when i use this mesure all CONTRAT appear in all PROJET :
SIREN = If(ISINSCOPE(CONTRAT[NUMERO CONTRAT]),1,0)
Do you have an Idea why i have this result ?
2 Replies
- amitchandak
Super User
nasolme , In matrix the TOP level is always is in scope
if you have dragged COl1, COl2,
Col1 is isisncope in all rows other than total
Col2 is not in scope at subtotal level
refer if needed
IsInScope - Switch Rank at different levels: https://youtu.be/kh0gezKICEM
PadycosmosSolution Sage
Hope this video helps:
