COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS PowerPlay => Topic started by: kazanec on 14 Aug 2007 10:46:24 AM

Title: PP Web: Nested Measures in Total
Post by: kazanec on 14 Aug 2007 10:46:24 AM
I working on a YTD view, broken down into periods, with multiple measures nested below. What I'd like is for the summary at the end of the columns to also include those nested measures. Currently, it only displays the column name and N/A for values. I know this is possible in PowerPlay Client, but don't know how to do the same thing in the Web Client.

Here's essentially what I'm looking for:

              Period 1                      Period 2                    YTD
            M1 | M2 | M3              M1 | M2 | M3         M1 | M2 | M3
Cus 1     1     1      1                1      1      1           2       2    2
Cus 2     1     1      1                1      1      1           2       2    2
Cus 3     1     1      1                1      1      1           2       2    2
Cus 4     1     1      1                1      1      1           2       2    2
Total       4     4     4                4      4      4           8       8     8

YTD is a calculated category.

Thanks!