I guess, there is no way to do this with the data fromyour example.
The only thing you could do is something like creating an object in designer which
gives a “relative” numbering of the rows within each emplyee, e.g.:
Id Name rel Dollars
0000123 Cindy 1 100.00
0000456 David 1 200.00
0000456 David 2 225.00
Then you can use “rel” as the dimension across in the crosstab.
Hope this helps
Walter
“Clayton, Cindy, HRBUS” schrieb:
I have data that I’d like to see in a crosstab. It’s laid out as follows
Employee_Id Name Dollars
0000123 Cindy 100.00
0000456 David 200.00
225.00I would like to see the dollars in the crosstab so the data looks like this
Employee_Id Name Dollars Dollars
0000123 Cindy 100.00
0000456 David 200.00 225.00
There is no distinguishing characteristic that I can use as the basis for
the crosstab columns. I thought about
somehow using rowindex() to number the rows within each employee_id but I
can’t quite get it to work.
name=“w.muellner.vcf”
Content-Description: Visitenkarte f¸r Walter M¸llner
Content-Disposition: attachment;
filename=“w.muellner.vcf”
Attachment converted: Macintosh HD:w.muellner.vcf (TEXT/ttxt) (000105B7)
X-Accept-Language: de-AT,de,en,en-US
Date: Fri, 5 Mar 1999 10:15:30 +0100
What’s wrong with contexts ???
WM
“Morris Phillip I (HBM)” schrieb:
Hi all,
Does anyone know if Business Objects have any plans to get shortcut joins
working properly in the near future. We do use them but there’s a limit to
how many frigs you can design in to ensure only 1 is ever needed.It’s either that or… contexts! shudder
–
DI Walter Muellner
Delphi Software GmbH, Vivenotgasse 48, A-1120 Vienna / Austria
Tel: +43-1-8151456, Fax: +43-1-8151456-21
e-mail: w.muellner@delphi.at, WEB: http://www.delphi.at
Listserv Archives (BOB member since 2002-06-25)