Combinatory Dimension or workaround

menta — Fri, 15 Jan 2016 10:19:43 GMT

Hi all,

i need to create a matrix that show in which sales department the customers buy.

The row dimension must aggregate all customer tha buy in all dept and after in all-1 dept for any possible combination.

Combinatory field	Sales dept A	Sales dept B	Sales dept C	Sales dept D	Sales dept E
5 of 5	1	1	1	1	1
4 of 5	1	1	1	1
4 of 5	1	1		1	1
4 of 5	1		1	1	1
4 of 5		1	1	1	1
3 of 5	1	1	1
3 of 5	1	1		1
3 of 5	1	1			1
...

Ther is a way to create something like this or if this is not possible a way to create an expression for any row with set analysis in AND mode?

Thank you

Re: Combinatory Dimension or workaround

mightyqlikers — Fri, 15 Jan 2016 10:24:38 GMT

give us some sample data and required output.

Regards

$@M.