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

FILTERING DATA IN CROSSTAB, HELP ME!

Started by lorenmario, 13 Nov 2013 10:19:45 AM

Previous topic - Next topic

lorenmario

Hello, can someone help me?

I need to make an active report with a crosstab, very simple.
In columns need to display some measures, and rows months.
Above Crosstab I have a data drop down list, with the stores. When I choose a store want the data to be filtered on the crosstab, but do not want to display the stores in crosstab, just want the values ​​reflect the store chosen filter.

I put the store in the crosstab query, but the Report Studio does not let me make the connection between the data drop down list and crosstab, only if the store is included in the Crosstab.

I tried to include the store in the crosstab and change the visibility of the column, but it did not work.

Does anyone know how to do this?

Tks!!! :)

RandomHunter

Hi,

take a data deck, put the store item in the query of the data deck. Drop a crosstab in the data deck and put the store item in that query too. Now link your dropdown list to the data deck on the store item. Finally make a master-detail relationship between the data deck and the crosstab on the store item.

For each store you choose, a new deck will be loaded for that store. Because of the master-detail relationship the data inside the crosstab will be filtered per store.

Hunter

sureshsugu

Hi RandomHunter,
                             You can view it below URL for better understanding of  filtering the crosstab using data drop down list.
http://bi-suresh.blogspot.sg/p/blog-page.html

Please let me know if you need more info on this,

Thanks.