Tables as a Data Staging Area

A computed item in the Results section becomes a mere data element when added to a Table section. Thus, the Table section can become an intermediate calculation staging area. This ability comes in handy in applications where you wish to place filters on computed items.

For example, suppose you want a report of the top ten producers in your organization. It is easy to add a computed item to your Results section that is based on the Rank function. (This function lets you find out each producer’s rank relative to the others.) However, when you try to filter the results based on that ranking, Interactive Reporting informs you that filters cannot be placed on aggregate items.

To get the results, insert a new Table section based on your Results section. Next, add all the relevant Results items, including the computed Rank field. Once Rank is a column in the table, it is no longer a computed item. It is a regular number on which you can now place a filter. Since the Table section is based on the Results section, your Top 10 report is updated automatically each time you run the query.