Multiply all combinations of a dimension

[Anonymous]

Hi!

I have a dataset that looks like this:

CustomerID	Fruit	Sales
1	Apple	5
1	Banana	3
1	Orange	2

And I would like to be able to multiply all combination of fruits for a customer, so that the result would be:

CustomerID	Fruit	Sales
1	Apple	5
1	Banana	3
1	AppleBanana	8
1	AppleBananaOrange	10
1	AppleOrange	7

The reason for this is that I would like to be able to filter on customers who have bought for example more than 3 Apple and Bananas combined.

Is this possible in any way? To loop through the fruit dimension or something? Other suggestions for my dilemma?

Thanks in advance!

[marcus_sommer]

To create this within the script could be very expensive especially by larger datasets. Therefore I suggest to check if you couldn't use the AND mode:

AND and OR

AND-Mode

- Marcus

[#3]

If you need combinations for selections & in the chart dimensions you need to create in script level only. Otherwise you can try on UI with options.

In the script level its Little complicated but it doable. I am little busy today so I will make script whenever I get a chance.