Page 23 - Microsoft Word - Using Adhoc & Analytics Expressview Reports - Participant Guide (SDL).docx

FORMAT TYPE
Number
Decimal Places 2
 Use 1000 Separator ,
 Use Currency Symbol $

18. Select any Revenue column row.
19. In the Selected Section, open the Style tab and modify the “Data Format” as
indicated below:
FORMAT TYPE
Number
Decimal Places 2
 Use 1000 Separator ,
 Use Currency Symbol $

20. Select any Revenue column footer.
21. In the Selected Section, open the Style tab and modify the “Data Format” as
indicated below:
FORMAT TYPE
Number
Decimal Places 2
 Use 1000 Separator ,
 Use Currency Symbol $

22. In the Format Pane, select the Filters icon, open the Standard tab, and modify
the filter criteria as indicated below:

Meet all of the following conditions:

FIN: GL Details.Account Type is null
Equal To
Revenue

ADM: Fiscal Period Setup.Fiscal Year is null
Equal To
Current Fiscal Year

23. Press the Run button to review the results.

Part 2: Add visualization to the report
1. In the Customer 1 group header, press the collapse icon to review the total in
the Revenue column.
2. Press Stop.
3. At the top of the Design Pane, press the Chart button.
4. From the Visualizations tab in the Format Pane, open the Type tab and select
“Pareto”.
5. In the Design Pane, navigate to the bottom right corner of the chart and press the
Show Chart only icon.
6. Press the Run button to review the results.

LESSON 2: ANALYTICS EXPRESSVIEW REPORTS
©2022 Unanet. All rights reserved. 23