Forum Discussion

gap's avatar
gap
Icon for Helper I rankHelper I
3 years ago

Filter Matrix Rows to be visible only when all columns have values

Hello   My goal is to hide rows on a matrix when not all columns have value. So i created the below filter. What i am counting is the the total columns on each row (columns will be the Year), where...
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
3 years ago

Filter=IF(ISBLANK([Basket Quantities Price]),1)

gap's avatar
gap
Icon for Helper I rankHelper I
3 years ago

This will not work, since it will not return same value for all the columns on the rows i want to keep, therefore the filtering will not be correct