Forum Discussion

jyaul786's avatar
jyaul786
Helper II
2 years ago

Hide/remove matrix rows

Dear Friend, i have one table with Level1,Level2,Level3,Level4 and value, i want to display in Matrix with hierarchy. Data: Level1 Level2 Level3 Level4 value Asset current bank bank1 ...
Need Help
Ahmedx's avatar
Ahmedx
Super User
2 years ago

try this

Flag = IF(MAX(Level 3) = BLANK()||MAX(Level 4)=BLANK(),0,1)

throw the measure on visual level ,  You can apply visual level filters in that you can select 1

jyaul786's avatar
jyaul786
Helper II
2 years ago

Hello,

i tried but complete Level 1 Income,Expense also filter.