COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: satishsure on 03 Apr 2015 05:40:12 AM

Title: Conditional side totals in cross tab
Post by: satishsure on 03 Apr 2015 05:40:12 AM
I have below cross tab.I need to show only totals of AA3.Currently we are showing all the side totals but it should be conditional.
As only AA3 totals only to be displayed.

Side GroupA       A1                |        A2                     |   AA3(A3 and A4)
Side Group         A1              |        A2                      |   A3                            |  A4

      val1 , val2  Total       | val1 , val2  Total        | val1  , val2  ,Total          | Val1,Val2, Total

                                val1 | val2         val1 | val2                    val1 | val2            val1 | val2
(http://image1.png)