Crosstab question

[Ogsebo]

Hello,

I want to set up a "crosstab" which displays the number of students taking a combination of (two) course options. The Row & Column would be the same dimension (if possible).

The result should look something like :

Course1 Course2 etc
Course1 11 2

Course2 2 20

etc


If you just set up a crosstab with course codes in the rows & the columns you only get the set of numbers in the Diagonal (Course1/Course1, Course2/Course2 etc). I've tried getting the course codes for row & column from different data providers on the off chance but that didn't seem to help.

Do you know if there is an easy way of doing what I want in B.O.?

Thanks,
Og

 

[skrandel]

You have to look at your data that is being returned. Do you have data that supports this.

Also, I think you need another dimension. If you use the same object on the left that you use on the top, then the behavior you describe is correct. You need to use a different object on one of the axes.

Steve Krandel
BASE Consulting Group

http://www.baseconsulting.com

 

[Ogsebo]

I don't think my data could support this. I think the only way is to export the results out to another package and manipulate them outside Business Objects.

Shame really! I'm probably sounding too fed up but most of my Business Object reports seem like houses of cards. I can get them 90% there but the last 10% seems to torpedo it all!

Ignore me & keep the faith!

Og