Crosstabs question

[ajen7118]

Hi,

I have questions regarding crosstabs to make my report. Could you please take a look at the attachments? and please help.

I am not sure if i am doing this right or wrong.

Thank you so much.

[Lynn]

Hi,

I have questions regarding crosstabs to make my report. Could you please take a look at the attachments? and please help.

I am not sure if i am doing this right or wrong.

Thank you so much.

I think your measures do not have an aggregate property specified. Change the aggregate property to specified and drag them in on the rows as you did at first. What you should see are the names of the measures in the rows and the values within the intersection of department and metric name.

[ajen7118]

Hi Lynn,

Thanks for your response and help. it really works.

I wonder if there is any book i can start with for learning Cognos. Do you have any recommendation?

http://www.amazon.com/IBM-Cognos-Report-Studio-Practical/dp/0132656752/ref=sr_1_2?ie=UTF8&qid=1454691627&sr=8-2&keywords=cognos

thanks again

[ajen7118]

Hi,

Thanks again for reading my question.

please see attachment document where I have a question.

Thank you so much

[sdf]

You can play around with data format properties, such as patterns. Can't you just align your format to the left?
But if you are happy to what you have right now, you can incorporate an if or case statement for your crosstab.

[ajen7118]

Thank you very much for all of your helps.

Can someone recommend me a good book to learn report studio or how to design the report?

thanks

[Lynn]

The user guides are a good place to begin along with any best practice documents published by IBM online. I'm not familiar with any third party books.