Hi,
I try on Cognos 11.08 create active report that:
- will have data toggel buton bar, with type of product. It is important that user of report can choose more than one type of product.
- table ( i tried crosstab), with months in columns, and measures in rows
- type of product should be "hidden filter", I can't put this field direct into crosstab.
I tried:
- standalone crosstab, with adding only in query TYPE of PRODUCT, but I didn't put this field into crosstab. Of course I can't create connection from toggel buton bar to crosstab, that filter TYPE of PRODUCT. If field isn't put direct into crosstab, creator of connection don't see it.
- second idea: i created data deck, that is filtered by toggel buton bar. Into data deck I put crosstab and I created master detail relationship between deck and crosstab. It works when I choose one type of product, but with more than one it doesn't work. I imagine that master detail relationship is based on "type of product = type of product", not on type of product in type of product".
- third idea: i used data list, however I can't use months as columns
I want achieve effect like crosstab and slicer in Excel.
thanks in advance for any idea