Skip to Content

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

Merging columns between 2 crosstab queries.

Hi

I have 2 crosstab queries. Both crosstabs are using the same rows but have different columns. Both crosstabs are using the same table with all the required values.

Crosstab 1

Client | Column A | Column B | Column C

1

2

3

Crosstab 2

Client | Column 1 | Column 2 |

1

2

3

I am trying to create one crosstab like below

Client | Column A | Column B | Column C | Column 1 | Column 2 |

1

2

3

The reason for this is i need to plot Crosstab 1's values as lines and crosstab 2's as markers on the same chart

Former Member
Former Member replied

You can construct a Command (query) that brings in all the data into a single view, and then use the "fields" from that view.

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