Sum On Columns

building reports webintelligence
1

Hi

I am facing problem in getting Sum of one particular column.
Description : The data displayed in report is like :

profile prodclass prodservice accbal exposure
1 a x 100 10
1 a y 100 20
1 a z 300 30
2 b p 20 1000
2 b q 40 2000
2 b r 60 3000

Now i want the sum of accbal as per the productclass and also below the product class name , but it should be done without Break as break causes some problem in Excel sheet.

Desired data:
profile prodclass prodservice accbal exposure
1 a x 100 10
1 a y 100 20
1 a z 300 30
600
2 b p 20 1000
2 b q 40 2000
2 b r 60 3000
120

Is there any way to do this ? I tried implementing by inserting Row , but row is inserted after every row.

If anyone knows , please suggest some idea.

Thanks
Aniket

aniketp :uk: (BOB member since 2007-10-05)

2

Sorry in the previuos post , data got jumbled. The sum should be displayed below accbal column.

Desired data:
profile prodclass prodservice accbal exposure
1 a x 100 10
1 a y 100 20
1 a z 300 30
600
2 b p 20 1000
2 b q 40 2000
2 b r 60 3000
120

Regards
Aniket

aniketp :uk: (BOB member since 2007-10-05)

3

try inserting a blank cell with the formula in it

Pragna (BOB member since 2007-07-25)

4

I tried inserting blank cell below the desired row , but it gives MULTIVALUE error , as the value is already there in that row.

And thanks for your quick reply.

Regards
Aniket

aniketp :uk: (BOB member since 2007-10-05)

5

Hi

Could you try to add a break on the profile collumn then apply your sum()?

superoliv :fr: (BOB member since 2008-06-17)