Hi,
i would like to add additonal data to the row-label in a cross-tab.
....................... C1 C2 C3
Customer1
.... add.Data1
Customer2
.... add.Data2
Customer3
.... add.Data3
How can i do that?
The link between the Customer-Table and the Extra-Data is the customer-id and a Date-Field (parameter of the report - used for filtering on a date-basis).
Table for extra data:
customer-id date amount
DATE is a parameter of the report.
Is there any way to do this?
(I use CR XI).
Result should look like this:
-
Selected Date (Parameter): 2009-02-02
...................................................... C1 C2 C3
Customer1 +
....amount on 2009-02-02 for C1
Customer2 +
....amount on 2009-02-02 for C2
Customer3 +
....amount on 2009-02-02 for C3
-
THX in advance,
Markus