You can create simple list reports, revenue reports, grouped lists, crosstab reports, charts, and custom groups.
List reports
Using Query Studio, you can create simple reports in column format. You can insert and format columns, move them around, add a report title, and change fonts.
Calculated columns
In Query Studio, you can create calculated columns from other columns in the report. For example, you can create a revenue column from the price and quantity columns. You can also delete the columns used in a calculation without affecting the calculated column.
Grouped list report
In Query Studio, you can group on a column to remove duplicate values. A grouped column automatically sorts the column values and generates summary information for the numeric data to which it refers. You can create sections to group on a column, filter on a column, and ungroup a column.
Crosstab report
In Query Studio, you can organize your report in a crosstab format. Crosstab reports summarize data so that you can analyze it in relation to both rows and columns. You can create a crosstab report to rotate rows and columns to insert a column into a crosstab, create sections, and apply templates.
Chart
In Query Studio, you create a chart from an existing report. Query Studio includes a selection of chart types that work with one or more columns of numeric data. You can view charts with or without the report information. You can create a column chart, hide the menu, create a pie chart, and move column around.
Custom groups
In Query Studio, you can assign a range of values from one column to a single group value defined in another column. For example, you can create two views of product margins in which margins are either 40% or more, or less than 40%. You can customize groups to group a column.