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

    Create Group that includes all original dimensions

    Kurt Marshman

      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
          Karthik Venkatachalam

          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
            Kurt Marshman

            Karthik,

             

            I appreciate your response back.

             

            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