| Business objects - little crosstable problem [message #130608] |
Mon, 01 August 2005 08:03  |
barabasmihai
Messages: 2
Registered: August 2005
|
Junior Member |
|
|
Hello.
I'm a newbie in Business Objects and I have a simple problem (first of many  ) but not also a solution. Who has a little of time and can help, please do so. I will start to describe the problem:
There are two tables:
Quarters Activities
ID Name Name Quarter_FK_ID
1 Q1 activity1 1
2 Q2 activity2 3
3 Q3 activity1 1
4 Q4
Hope it's clear enough, we have activity1 twice in the first quarter and activity2 once in the third quarter.
I have tried and tried to create a crosstable who looks like this
Q1 Q2 Q3 Q4
activity1 2 0 0 0
activity2 0 0 1 0
but without success. The closest solution I have found, was that I return a cross join between the two tables and as crosstable body a variable "=(If (<QuarterId>= <QuarterIdFK>) Then Count(<ActivityNr>) Else 0)", BUT, in this case, I obtained this:
Q1 Q2 Q3 Q4
activity1 1 0 0 0
activity1 1 0 0 0
activity2 0 0 1 0
Thanks in advance,
Mihai.
|
|
|
|
| Re: Business objects - little crosstable problem [message #130610 is a reply to message #130608] |
Mon, 01 August 2005 08:08  |
barabasmihai
Messages: 2
Registered: August 2005
|
Junior Member |
|
|
I will "redraw" the tables, I saw that the spaces are not taken in consideration
Quarters------------------------------Activities
ID---Name-----------------------------Name--------Quarter_FK_ID
1----Q1-------------------------------activity1---1
2----Q2-------------------------------activity2---3
3----Q3-------------------------------activity1---1
4----Q4
I have tried and tried to create a crosstable who looks like this:
--------------Q1-----Q2-----Q3-----Q4
activity1-----2------0------0------0
activity2-----0------0------1------0
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
