2 Replies Latest reply on Apr 17, 2017 9:44 AM by Kurt Marshman

# Create Group that includes all original dimensions

Using 10.2

I created a calculated field called "Container" that uses the following formula:

IIf([Prod Line]="BE" Or [Prod Line]="BB","Unit",

IIf([Package Qty]=4 And [Prod Class]="FC","1 - 1 Gal",

IIf([Package Qty]=1 And [Prod Class]="FC","2 - 2.5 Gal",

IIf([Package Qty]=55,"3 - 55 Gal",

IIf([Package Qty]=275 Or [Package Qty]=264,"4 - 275 Gal",

IIf([Package Qty]=330,"5 - 330 Gal",

IIf(([Qty Sum])<6499 And [Prod Class]="FB","6 - Truck",

IIf(([Qty Sum])>6500 And [Prod Class]="FB","7 - Rail",

"8 - Other"))))))))

Create a group called "9 - Bulk" by grouping "6 - Truck" & "7 - Rail" - end result is

"Unit"

"1 - 1 Gal"

"2 - 2.5 Gal"

"3 - 55 Gal"

"4 - 275 Gal"

"5 - 330 Gal"

"8 - Other"

"9 - Bulk"

Is there a way to show the original dimensions "6 - Truck"  and "7 - Rail" in the Group - end result looking for:

"Unit"

"1 - 1 Gal"

"2 - 2.5 Gal"

"3 - 55 Gal"

"4 - 275 Gal"

"5 - 330 Gal"

"6 - Truck"

"7 - Rail"

"8 - Other"

"9 - Bulk"

• ###### 1. Re: Create Group that includes all original dimensions

Hi Kurt,

If you don't include the original dimension in the analysis, it wont show.

Once you add it, its going to break it down as below.

You can try string concatenation, to combine as a single field, but I did not try that. So, I don't know if that will work or not.

• ###### 2. Re: Create Group that includes all original dimensions

Karthik,

The project -

Data will end up feeding a map.

"Container" dimension will be added as a filter.

User will select from the following to change the map:

"Unit"

"1 - 1 Gal"

"2 - 2.5 Gal"

"3 - 55 Gal"

"4 - 275 Gal"

"5 - 330 Gal"

"6 - Truck"

"7 - Rail"

"8 - Other"

"9 - Bulk" = "6 - Truck" + "7 - Rail"

If I group "6 - Truck" & "7 - Rail" as "9 - Bulk" then "6 - Truck" & "7 - Rail" is no longer available in the filter.

If I do not do a group then "9 - Bulk" is not available in the filter.

The only solve I have currently... is to do a stacked custom sql union query, which I am trying to prevent doing if possible.

So in your example.... have 9 - Bulk(\$2,581) = Envelopes(\$716)+Labels(\$287)+Paper(\$1,578), but continue to show Envelopes, Labels, Paper as Sub-Category Group

Sub-Category (group)

9 - Bulk              \$2,581

Accessories       \$1,725

Art                     \$538

Binders              \$10,712

Envelopes         \$716

Fastners            \$50

Furnishings       \$3,951

Labels               \$287

Paper                \$1,578

Phones             \$8,691

Supplies           \$128