Post Author: ck1938
CA Forum: WebIntelligence Reporting
I have a report that I want to use to make an Xcelsius document. Xcelsius has some formatting requirements that I need Webi to address. The report shows Siebel activity by region and sales manager, where usage is summed by region and in total. (See below) There are seven regions and not every region uses each activity so if I create seven separate tables the column headings of activity type are out of sync and I cannot use the excel output to create the xcelsius file. To address this I created one report with breaks so that I can get the sum to display for each region and all the activity data for each region stays in sync. I'm now being asked to put the total at the top of each break instead of the bottom. I can do this for Mid Atlantic by adding a row at the top of the chart and entering in the variable for that specific region. When I get to the rest of the regions if I try to enter a new variable into one of the fields between the breaks it populates that relative field in all the breaks, so I cannot get region specific data. If I enter in a variable for the Northwest region that variable populates all regions. If I try to add a new row it puts spaces between each entry which makes the report unusable for use with Xcelsius. Has anyone had any luck with getting the sum to display at the top of a column in similar conditions?
Region 1
Region 2
Sales Manager
Activity Other
Cust Conference
Call
Cust
Demonstration
Cust Post Sales
Support
Cust Presentation
Cust Selling
Appointment
Cust Training
Internal Meeting
National
National
All
8457
1365.5
577
1973
1203
46774
3192
3429.5
MAC
Mid Atlantic
Smith
3547
23.5
49
486
49.5
4145
142
429
MAC
Jones
184
3
6.5
187.5
4
2898
13
76
MAC
Lebau
1426.5
27
27
336.5
62.5
3275.5
323.5
378.5
MAC
OTHER DIRECT REPORTS
108
1049.5
1
6.5
Mid Atlantic
REGION TOTAL:
5265.5
1103
82.5
1010
116
10319.5
478.5
890
MWC
Mid West
Nguyen
103.5
12.5
11
28.5
17
956.5
41
9.5
MWC
Otto
51
2
23.5
32.5
48
1983.5
126
45
MWC
Bismarck
206.5
33.5
13.5
41.5
24
1467
78.5
11.5
MWC
Marte
70
10.5
17.5
6
1395
120.5
57
MWC
Sanderson
14.5
3
15
9
619
32
70.5
MWC
OTHER DIRECT REPORTS
1
8.5
32.5
726
15
2
Mid West
REGION TOTAL:
445.5
52
58.5
143.5
136.5
7147
413
195.5
NCC
North Central
Jarvis
463
10
11
73.5
18.5
2112.5
24.5
75
NCC
Bradley
467.5
13.5
50.5
15
1561.5
92.5
272
NCC
Roberto
231
18
9
4
84.5
1870
157.5
158.5
NCC
OTHER DIRECT REPORTS
1
10.5
48
172
310.5
4
10
North Central
REGION TOTAL:
1162.5
52
68
128
290
5854.5
278.5
515.5