cancel
Showing results for 
Search instead for 
Did you mean: 

Addition across rows & columns

Former Member
0 Kudos

Hi all,

I am new to Business Objects so please bear with me. I am using a cross tab in Web intelligence.

I want to compute sum across rows & columns & divide the cells with this sum. foreg.

interval1 interval2

Count Count Sum

A 1 3 4

B 2 3 5

Sum 3 6

Now I want to first obtain sum across column & rows. and then divide cells in interval1 with 3 & in interval2 with 6

Thanks in advance.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

If you go to CrossTab property. Check the box. Show table footer.

You will get blank row and column. If you put your measure here you will get sum across rows ans column.

Please elaborate next point once again.

Former Member
0 Kudos

Hi srrachna ,

Thanks for reply.

Actually the issue is -:

This the input data

1. Hour interval

2. Count

3. Item

Now on Cross Tab the data is arranged as follow -:

Business Magzines 4 3 6

% of Business Magzine

Literature 5 3 1

% of Literature Books

Now the purpose is calculate sum across row & column . Use this sum to calculate %.

Now Count gives distribution in specific intervals.

I need to have total . Let's say of first column i.e. 9.

Use this SUM(9) & calculate % of particular product.----> % of Business Magzines (4/9) *100

% of Literature books (5/9)*100

Items may change depending on the data entered i.e. it may grow more than these two items or reduce.

Edited by: sorav84 on Feb 10, 2012 3:57 PM

Former Member
0 Kudos

Hi Sourav

The sum of rows and columns can be performed directly. If u go to the Summation option in Webi Report indicated by Sigma Symbol. Here if you go down u will find the option called Default aggregation. It will give you the sum of rows and columns.

Regarding the Percentage thing ...specify where you exactly require...I mean u want each row and its corresponding percentage just under it or any other way?

Reagrds

Shyam Rapeti

arijit_das
Active Contributor
0 Kudos

Use the following formula for Intervals:


Interval1 Count : = [Interval1 Count]/Sum([Interval1 Count])
Interval2 Count : = [Interval2 Count]/Sum([Interval2 Count])