Hi,
Creating a crosstab, and want to show multiple data items on the left hand column of a cross tab, and months across the top.
The data I'm looking to display contains 4 data points. Received applications, Completed applications, and withdrawn applications. The 4th is the net of these (received less completed and withdrawn). The first three come from separate queries, joined to bring all data items on 1 row. The row contains month, received total, completed total, and withdrawn total, so I can then do the net total.
As stated above, I want to display Received, Completed, Withdraw and Net on the left, with Months across the top.
However, when I put each of these items into a cross tab, I'm not getting any results. I don't have any data items in the "measures" part in the middle, as I though that when you put the totals on the "edge" it will display these.
What Am I doing wrong? Is there supposed to be a calculation applied on these totals?
Thanks,
Quote from: jasonmacpei on 13 Mar 2018 07:08:34 AM
Hi,
Creating a crosstab, and want to show multiple data items on the left hand column of a cross tab, and months across the top.
The data I'm looking to display contains 4 data points. Received applications, Completed applications, and withdrawn applications. The 4th is the net of these (received less completed and withdrawn). The first three come from separate queries, joined to bring all data items on 1 row. The row contains month, received total, completed total, and withdrawn total, so I can then do the net total.
As stated above, I want to display Received, Completed, Withdraw and Net on the left, with Months across the top.
However, when I put each of these items into a cross tab, I'm not getting any results. I don't have any data items in the "measures" part in the middle, as I though that when you put the totals on the "edge" it will display these.
What Am I doing wrong? Is there supposed to be a calculation applied on these totals?
Thanks,
What is the setting for detail aggregation on these metrics? Try setting to Total if they aren't already.
Have you viewed tabular data for your joined query to verify the results are as expected?