nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Group in a Cross Tab table

csasaki

Hi,
I have made a DataCube and from that made a Cross tab like the one seen in the attach file.
I want to group the data because want to aggregate the hours by the name of the person ( 1st field).

Can i do that here?

Any ideas?

Find more posts tagged with

Comments

mwilliams

Can you explain this a little bit more? Are you meaning you want a crosstab for each person or something else? Let me know.

csasaki

This is what i expect to do with the group by :

csasaki

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="79208" data-time="1309273130" data-date="28 June 2011 - 07:58 AM">
Can you explain this a little bit more? Are you meaning you want a crosstab for each person or something else? Let me know. </blockquote>
 
Well i have this in my results : 
 
Analyst1 Tester 1 - Req. 1 - Open 4 6 7 2 
Tester 2 - Req. 5 - New 2 3 2 3 
 
Analyst2 Tester 1 - Req. 3 - In Prog 3 3 4 2 
Tester 2 - Req. 7 - New 2 1 2 4 
 
 
I want to add something like this 
 
7/1 7/2 7/3 7/4 ... 
Analyst1 Tester 1 - Req. 1 - Open 4 6 7 2 
Tester 2 - Req. 5 - New 2 3 2 3 
Sum 6 9 9 5 
_______________________________________________________________________ 
Analyst2 Tester 1 - Req. 3 - In Prog 3 3 4 2 
Tester 2 - Req. 7 - New 2 1 2 4 
Sum 5 4 6 6

mwilliams

If you click on the icon next to the outer row dimension, "analyst", there is an option for "totals". If you click on this, you will see an option to add a "subtotal" and a "grand total". What you're wanting is the subtotal option. So, if you select this option, you should get what you're wanting. Let me know. This option may not be there for early versions of BIRT. I'm not sure on that.

csasaki

Thanks Mr. Williams it worked gread =D