Skip to Content
0
Former Member
Apr 11, 2008 at 03:08 PM

Group By / Count

14 Views

Post Author: Glux

CA Forum: WebIntelligence Reporting

Hi to everyone,

I'm starting to use BI XI and find it very interesting. However it is quite tricky to find info or how to adapt my own logic to it ;).

Well, hereinafter what I have. A table showing for each customer if they have the service (1) or not (empty)

Service 1

Service 2

Service 3

Customer 1

1

1

1

Customer 2

1

0

1

Customer 3

0

1

0

Customer 4

1

1

1

Customer 5

0

0

1

Customer 6

0

1

0

And what I want to have. A table that summaries how many customers have the same combination of services

Service 1

Service 2

Service 3

Number of customers having this set of services

1

1

1

2

1

0

1

1

0

1

0

1

0

0

1

1

0

1

0

1

And I really don't find how to do it. Except exporting my individual data to Excell and doing a "subtotal".

Thanks for your help.

Regards.