Brands association chart

[#1]

Hi everyone,

I have a classic fact table like this one (with almost 50 000 000 rows and more than 3000 brands):

OrderID	Product	Brand
1	A	AAAA
1	B	AAAA
1	C	BBBB
2	D	CCCC
2	E	AAAA
4	F	BBBB
4	G	BBBB
5	H	CCCC

I want to have the brand association. For exemple:

     - if i select brand AAAA, associated brand are BBBB and CCCC

     - If i select brand CCCC, associated brand is AAAA

The node is OrderID.

Is it possible to have a TOP 10 associated brand chart ? like this one:

TOP 10 Brand (dimension)	Rank 1 Associated brand (expression)	Rank 2 Associated brand (expression)	Rank 3 Associated brand (expression)
AAAA	BBBB	CCCC	SSSS
XXXX	XXXX	XXXX	XXXX

I can already have associated brands with this expression:

only({$<OrderID=P(OrderID), Brand=E(Brand)>} Brand)

Please see attached app.

Thanks for your help !

Quentin

[#2]

Anyone ?