COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Active Reports => Topic started by: teresa.danna@gmail.com on 12 Jan 2016 02:25:06 PM

Title: Suppress Rows Upon filter using Data Check Box Group
Post by: teresa.danna@gmail.com on 12 Jan 2016 02:25:06 PM
Good afternoon!

I'm not sure if anyone has figured out a solution to this...

I have the following data and Data Check Box Group:

Check which periods you would like to see: 1 | 2 | 3 | 4 | 5

                Period 1  |  Period 2  |  Period 3  |  Period 4  |  Period 5
Proj1             1                  -               3            10,000        30
Proj2           10,000           -            30,000       100,000        -
Proj3              -              10,000         5               -               -

If I click on just period 1 I expect that I would see Proj1 & Proj2, but not Proj3 after having clicked suppress rows on both the Data Check Box Group and the crosstab, however that's not the case. Instead I get all three rows - which shows Proj3 as a "-"

Thoughts?