Actual vs Planned Revenue Report

Select Sales and Marketing(Cube) package to then click Launch->Report Studio to create a new report.

Select List type report.

1. List

• Drag Region, Year, Order method type, Product type, Product from Insertable Objects.
• Drag Revenue, Planned Revenue from measure of Insertable Objects.

2. Adding Calculation to Reports

• Drag Query Calculation item from tools of Insertable Objects and input name as "Different" and input expression as Revenue-PlannedRevenue.

3. Grouping

• Select the column which you want to group it in report and then click "Group/Ungroup" icon in standard toolbar.

4. Sorting

• Select the column which you want to sort it in report and then click "Sorting" icon in standard toolbar.

5. Summarizing

• Select those columns using "Ctrl" button which you want to summarize them and then click "Aggregate" icon and then select "Total" in the list to summarize them.

6. Multiple Prompts

• Select those values which you want to add them in the prompt page to let the user to select before running the report. Select those values and click "Build a Prompt" to create a prompt page, it will display the prompt page.
• Click "Run" to run this report.

Create Header

• Select the Region column(notes: it should be grouped if you want to let this column to be a header) and click header icon and select create header and footer.
• After create it as the header, you maybe need to delete this column from the list. Then you can select the column list and then select "Cut" icon to delete it from the list.
• You have to change the properties Miscellaneous->Classes->Section header cell. Then the column will locate in the top.