Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Detail-Data in Cross-Tab

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

Former Member
Former Member replied

Hi Markus,

Thanks for your excel screen capture.

I have prepared a tables as per your excel screen capture and I could able to extract the required information in cross tab.

Please find below are the steps :

--Add table1 and table2 to your report.

--Make join as Inner on Customer

--Open cross tab and place

Table1.date on Columns:

Table1.Customer, Table2.Amount on Rows

Table1.Value on Summarized fields

Go in Customize StyleRows--select table1.customer and suppress subtotal.

--Remove check boxes from column totals on top, row totals on left, Repeat row labels.

--Check Suppress Row Grand Total, Suppress Column Grand Totals.

--Go in Record Selection and Table2.date > Startdate

Now you will get the desired output.

Thanks,

Sastry

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question