multidimensional views

(redirected from Pivot table)
Also found in: Wikipedia.

multidimensional views

Looking at data in several dimensions; for example, sales by region, sales by sales rep, sales by product category, sales by month, etc. Such capability is provided in numerous decision support applications under various function names. For example, in a spreadsheet or database, a pivot table provides these views and enables quick switching between them. See OLAP and MDX.


Multidimensional Views
The ability to quickly switch between one slice of data and another allows users to analyze their information in small palatable chunks instead of a giant report that is confusing.
References in periodicals archive ?
A pivot table is included in the file and can be changed to present views of actual and forecasted unit shipments, growth rates, revenue, average selling price, and installed base.
This month we'll look at a question sent in by a reader: How can you create a pivot table that will show a rolling 12 months of sales?
An apparent gap exists in the finance field for taking advantage of the power of pivot table. The authors of this study attemp to fill this gap by using pivot table to extend the test of January effect.
When we want to display a summary report in a table format, we can use a Pivot Table. When we want to display it in a graph, we can use a Pivot Chart.
The tutorial explains that Excel is an excellent OLAP tool, and multidimensional data stored in a database can be imported into Excel and used in the creation of a pivot table for OLAP purposes.
A most powerful tool to emerge from the RRD database Is the pivot table function in Excel.
The discount covers all products within the Ranet OLAP product line, including Ranet OLAP Pivot Table for HTML5 and Ranet OLAP for WPF and Silverlight based WinForms applications.
Minemax Scheduler 6.2 also includes further enhancements such as the definition of a per-period variable discount rate, improved pivot table outputs, searching and filtering of lists, selection of multiple source files on import and general bug fixes.
o Interactive pivot table and charting capability allowing users to preview and drill down on detailed trade data
A pivot table uses data organized on two dimensions to create a three-dimensional table.
Black and white screenshots illustrate how to format pages, add tables and charts, enter data on a spreadsheet, insert a formula, filter data, modify a pivot table, animate text and graphics in PowerPoint slides, organize email in Outlook, and connect appointments with the calendar.
A notable miss on Excel for Android is that it doesn't allow users to create a pivot table that comes in handy when updating summaries of sales totals.