Crosstab Issue

[rwaugh]

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!

[MFGF]

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.

[rwaugh]

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.

[MFGF]

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.