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
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.