I was wondering if within Matrix mode we had the option to hide 0 value columns being returned. For example we have to Matrix widget on a dashboard that houses 70 items, depending on the dimension filtered on this would reduce the amount of items applicable from the 70 to 10. After applying filter on this matrix mode, all 70 items will be column headings regardless of value and requires considerable scrolling to find the value you need. Having the system hide the columns not populated would reduce the list considerably.
I appreciate that in some cases you would want to see the columns regardless of zero value. So could this be an option similar to “Show Net Zero” such as “Hide unreferenced columns”?