Forum Discussion

grayscg's avatar
grayscg
Advocate I
3 years ago

Matrix with no blank rows

 

I have the above matrix, simplified for this example. Those dates are sepereate values from seperate tables. I want the matrix to take out the row when there is no data. Is this achievable? Applying a simple visual filter for example "Table1Date is not blank" completley removes table2 from the matrix. 

 

Desired Output example:

Table1 
LatestTable1Date3/28/2023
Table2 
LatestTable2Date  4/17/2023

1 Reply