If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Crosstab report

Started by 1#griff, 24 Jun 2009 09:02:52 AM

Previous topic - Next topic

1#griff

 ???

I am trying to create a crosstab report that will just show the detail information. When I drag the item over to measure area I dont want any aggregate function. I just want to show the true value thats in the database. Is this possible with a crosstab?

Gollapudi

Intially you should change your Query Property... "Auto Group & Summarize" to "NO", then it wont summarize any values.. will just present as how they were in ur Database.

And the other thing a crosstab will always shows Data in a 2 dimensional grid.. means when you add Year in Column and Product in Row Level.. then your measure.. will shows data for every Product in that Perticular Year...

Thanks,
Gollapudi.