Skip to Content
0
Former Member
May 15, 2008 at 01:23 PM

Placing a sum on top of a column instead of on the bottom for a report with breaks

48 Views

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