Summary

[JuliaM]

Hi everybody,

I have dimentional report, very simple - sales by customer groups, that shows both group and customer. Some customer groups have several customers, while most - only one.
Is there a way to not display summary where there is only one customer per group??

Thank you!

[charon]

hello Julia,

could you be so kind and descibe your cognos challenge a bit more detailed? I have troubles to understand what exactly the goal is your trying to achieve.

[JuliaM]

This is how the report looks
Group1 Cust1                    1   1 
           Cust2                    3   3
           Cust3                    2   1
Summary of Group1            6   5

Group2 Cust1                    4   4
Summary of Group2            4   4

There is only one customer in Group2, and summary of Group2 contains the same numbers as the Group2 Cust1 line; I'd rather not diaplay this summary

Does that make it sense?

Thank you

[adik]

are you interested in achieving this with a relational database or DMR/OLAP?
with relational I can help you, but with DMR/OLAP i haven't found a solution yet.

[JuliaM]

Thanks! I'm working with dimensional. Let me know if you find a solution :)

[RKMI]

Hi,

Create a count data item which shows number of cust for the group. Then for the summary in a case statement where Cust count is >1 then summary display. (or) Nest the count to the summary then add the count as filter count > 1. (For some reason I think this might throw an error). Unfornately, I don't have a dimensional model to try the suggestion but, it works in relational.

Thanks,
RK

[adik]

i've tested what RKMI proposed and this does not work for dimensional data. still trying to find a sollution...