Skip to Content
avatar image
Former Member

Cross Tab Report Design - Combinations

Hi,

I was wondering if someone can help me with a report design. Lets say I have a list of items and the list of each customer that buys. I count up the different items and then I want to compare in a grid where two customers buy the same items

Item Customers
Apple ABCD
Banana ABD
Mango ACD
Peach ABD
Strawberry BCD
Cranberry AD

A - 5 Items Purchased
B - 4
C - 3
D - 6

Overlap - (Distinct Count of the item names in A + Distinct Count of the item names in B) - Count of the item names in both A and B -
(5 + 4) - 6

__A B C D
A 0 3 2 4
B 3 0
C 2
D 4

Any idea on how to approach this type of cross tab or even this type of report in Business Objects

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers