Calculating counts based on existing columns

[MurrayR]

Hi

I am new to Cognos and the Forum and appreciate any help provided.

Using Cognos 10.1 with Cube dimensional data - looking to generate a Report Studio report that can produce the following tabular output below: 

Column 1 = Country
Column 2 = Customer count in each Country
Column 3 = Product Count of those customers in Column 2
? = Generate a breakdown table of the customer count (col 2) who have purchased 0-5 products (Col 3)?

Column 1          Column 2                  Column 3                      Customers with 0-5+ products?
                                                                                                 0       1        2       3        4        5     5+    total
Country 1           100                           200                                         50    10      30      10                      100
Country 2            50                            150                                         20                        20      10             50

Thanks

[Lynn]

I don't think others on the forum are aware of what measures you have to work with in your cube or what your dimension hierarchies look like.

A little more information might help elicit a response.