COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Active Reports => Topic started by: b737 on 17 Apr 2016 11:50:25 AM

Title: Filter crosstab using Data discrete slider - option Range
Post by: b737 on 17 Apr 2016 11:50:25 AM
Hi,

I am trying to create active report where I have Data discrete slider with Month as data and crosstab. Month is independent Dimension, 1 to 12. At Data discrete slider I have checked option Range because I want to choose one month (January) or interval (March-October). Problem is that I do not have Month in crosstab, because, I want to have summarized data when I choose interval (March-October), so I can not put Month in cross. I have tried to put crosstab in Data deck, and connect with Month and Master-deatil relationship, but then is working only when I choose single month, not interval, then entire crosstab disappears.

How can I resolve this problem.

Thanks