For as long as mTAB™ has been around, it has offered the Filter option and we continue to enhance this area.

Filter Description Display Options

mTAB™ has always displayed any selected flter at the top of the spreadsheet for all to see. This continues to be the case, but with the more recent versions of mTAB™ offering up to 26 filter questions, these descriptions often become rather long.

When exporting mTAB™ results to Excel, these long descriptions may become difficult to view in just one cell and as such mTAB™ now offers the user the choice of whether their filter description should be listed in one cell or instead if it should split across multiple rows.

By going to the View menu, selecting Global Preferences and then the Settings tab, the user sees the following screen.

 

Here they see a new option at the bottom of the screen allowing them to choose whether Filter Descriptions will be displayed in a single cell or across multiple rows. As with all Global Preference settings, once set, the selection is saved and will remain as such, until the user goes back in and changes it.

Filter - Auto Suppress

In the Filter Panel you will now see an option at the top right titled 'Auto Suppress', with options for Rows and Columns.

The idea of this option is for mTAB™ to examine the tab that is being run and to discover if there are any columns (or Rows) of information that are being made completely zero by the application of the filter. If there are and this option is selected, then those columns (or Rows) are hidden from view and do not show up on the resulting tab.

If a tab with models on the columns and brand on the filter is run without either of these options checked, then it will look like this:

You will note that due to the filter being set to only allow respondents through that selected Brand B, the columns showing models from other brands do not show any data. If we now check the 'Auto Suppress: Columns' option in the Filter panel and run the tab again, the resulting spreadsheet looks like this, with the zero columns hidden from view.

 

Similarly, if we had a filter applied that caused some rows to become completely zero, then we could also check the 'Auto Suppress: Rows' option in the filter panel and they too would be hidden from view.  Simply returning to the Filter panel and unselecting these options would allow us to rerun the tab and see the original results once more.

Filter Option Enhancements