Forum Discussion
Remove fields with blanks from a matrix table
Hi there, I have a table of records. When I click on a record it then populates a matrix table as in figure B with a number of date fields populated. I need to dynamically change this matrix tabl...
Hi obothewizard ,
i see no attachements but maybe this points you in the right direction:
When you've selected the visual (matrix in your case) go to the filter pane.
there is an option to filter out all blank values. In other words; select all values and deselect "blank" or "null"
Hi there,
Thanks for your response.
Unfortunately I can't do that, and nor does deselecting 'show data with no values' work either. I have a workbook that demonstrates the problem but it looks like there is no way to share without a dropbox/one drive upload link being supplied by a responder. So stupid!