mTAB™ now supports displaying a separate TopN report for each worksheet within the Layer view. In previous versions of mTAB™, the TopN report was limited to the single worksheet that was selected.

Start setting up a tab by including at least one question in Rows and Columns.

Next, include a question in Layer.

To display a TopN report for each worksheet within the Layer view, select the following options.

Create Layer from: Single Question
Orientation Options: Outside Worksheets 

Run the tab and start the TopN sort process either by highlighting the columns that should be included in the TopN report or by clicking on the gray rectangle between column A and row 1. 

Clicking on this will highlight the entire contents for TopN. 

Go through the usual TopN steps:

- Click the TopN icon to the right of the lightning bolt.
- Select Display Options
- Specify the N value of responses to display.

In the example shown to the right, the worksheet "30 To 34" is selected in white by default, since it was the first response in the Age question used in the Layer view.  The rest of the age bracket worksheets are grayed out, in the background.

Notice the sort order for Brand C, Ages 30 to 34.  The top 3 responses are:

Value for the Money       26.43%
Celebrity Endorsement  14.98%
Technical Innovations     11.47%
Sample Total                   106

To view the TopN report for a different worksheet, simply click on the worksheet stub, located at the bottom of the mTAB™ screen.

In the image (left), notice the worksheet,
"35 To 39" is now selected as indicated by the worksheet stub highlighted in white.

Notice the sort order, percentages, and sample totals have changed from the previous example.  

This TopN report now reflects data for Brand C, Ages 35 to 39.  The top 3 responses are:

Value for the Money       22.26%
Celebrity Endorsement  12.62%
Brand Reputation           11.42%
Sample Total                   107 

To view a TopN report for additional worksheets within the Layer view, continue to click on each remaining worksheet.  The contents of each worksheet will be sorted accordingly.

TopN Report in Layer Outside Worksheets