on 02-10-2012 1:02 PM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
Use the following formula for Intervals:
Interval1 Count : = [Interval1 Count]/Sum([Interval1 Count])
Interval2 Count : = [Interval2 Count]/Sum([Interval2 Count])
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.