Grouping Dimensions

[#1]

Hi

I have 4 dimensions in my main table that I need to group.

1. Apple

2. mango

3. Pineapple

4. Banana.

I need to group all of these as "fruits". How do i do it in the scrpit?

[Anonymous]

Have you looked into the CrossTable() function?

[#3]

I have but I cant seem to work my way around on this. Are you ok to provide some guidance?

[Anonymous · Accepted solution]

In the script:

if(wildmatch(YourFieldName, '*apple', 'mango', 'banana'), 'Fruit', YourFieldName) as YourNewFieldName

(Here *apple covers both apple and pineapple)