Hello,
My apologies if this type of question has already been asked. I am attempting to do some kind of crosstab report without having to manually do it in Excel. The data that I am working with has a Supervisor Name, Worker Name, other data, a column that says "Yes" or "No" depending on the calculations in the report. What I would like to have is a crosstab that lists the counts of Yes and No for each Supervisor and Worker.
Something like:
| | Yes | No |
Supervisor | Worker One | 1 | 5 |
| Worker Two | 4 | 15 |
| Worker Three | 0 | 10 |
Any thoughts? When I drag the Supervisor Name and Worker Name into the crosstab it is fine. When I add the column with Yes and No it doesn't do any counts at all for yes and no. So I basically get a crosstab with the Supervisor and Worker with an extra column of nothing.
Thanks in advance!
Quote from: rwaugh on 21 Mar 2018 07:34:38 AM
Hello,
My apologies if this type of question has already been asked. I am attempting to do some kind of crosstab report without having to manually do it in Excel. The data that I am working with has a Supervisor Name, Worker Name, other data, a column that says "Yes" or "No" depending on the calculations in the report. What I would like to have is a crosstab that lists the counts of Yes and No for each Supervisor and Worker.
Something like:
| | Yes | No |
Supervisor | Worker One | 1 | 5 |
| Worker Two | 4 | 15 |
| Worker Three | 0 | 10 |
Any thoughts? When I drag the Supervisor Name and Worker Name into the crosstab it is fine. When I add the column with Yes and No it doesn't do any counts at all for yes and no. So I basically get a crosstab with the Supervisor and Worker with an extra column of nothing.
Thanks in advance!
Did you drop anything into the cells of the crosstab? I'm guessing you can add a query calculation with an expression of 1 and use this?
MF.
Thanks for the reply MFGF! I've attached a snippet of what my crosstab looks like at the moment. Not sure if that will help or not. I dragged the column that contains the Yes or No value into the cells of the crosstab. I'm sure it's something simple that I am missing and can't for the life of me figure it out.
Quote from: rwaugh on 21 Mar 2018 08:19:18 AM
Thanks for the reply MFGF! I've attached a snippet of what my crosstab looks like at the moment. Not sure if that will help or not. I dragged the column that contains the Yes or No value into the cells of the crosstab. I'm sure it's something simple that I am missing and can't for the life of me figure it out.
Hi,
Crosstabs will only display measure values in the cells. Anything that is a descriptive attribute or character based data type will not work. Do you have any measure values? If you have another measure, you could add a query calculation to your report to use in the cells and code the expression as [your package].[your query subject].[your measure query item] / [your package].[your query subject].[your measure query item]
This will return a value of 1 for every row of data, which should then be aggregated to give you your counts (hopefully)
Cheers!
MF.