Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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:
- Marcus
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.