Merging columns between 2 crosstab queries.

[Former Member]

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 · Accepted solution]

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

[former_member11696]

No...

[Former Member]

Conceptually, you want a join of two crosstabs.

I don't how how to do that. Can you have a crosstab built from other crosstabs?

--

Tim

[Former Member]

Hi

You need to elaborate your requirement.

You can create a cross tab with all the columns and rows as per requirement. And you have already mentioned that you have same rows in both the cross tab.

So you just need to create a cross tab with all the 5 required columns and the rows and summary values.

Regards

Sourashree

[Former Member]

I have tried adding all the columns into 1 crosstab but it starts grouping them and does not put the columns next to each other.

Basically why I am trying to do this is I am trying to plot column A to C on a chart as a line chart but at the same time plot Column 1 and 2 as markers.