Skip to Content
0

Cross Tab Report Design - Combinations

Sep 12, 2017 at 03:18 PM

13

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers