Merging columns between 2 crosstab queries.
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.
Client | Column A | Column B | Column C
Client | Column 1 | Column 2 |
I am trying to create one crosstab like below
Client | Column A | Column B | Column C | Column 1 | Column 2 |
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
You can construct a Command (query) that brings in all the data into a single view, and then use the "fields" from that view.