3 Replies Latest reply on Sep 24, 2018 5:22 AM by Jim Dehner

    conditional grouping dimensions

    Thomas Kont

      Hello everyone,

       

      i need some support in regards to grouping dimensions based on conditions.

       

      The screenshot below comes from the Superstore Datasource. I am trying to create an additional group on the "Sub-category" level.

      If the sales amount is less than 200K, then please aggregate the amount and group it "small items".

      The Sub-category "Envelopes, Fasteners, Labels" should be grouped under "small items" and the amount respectively aggregated.

       

      Could someone help on this topic please. Is it possible to do this conditional grouping without creating additional calculation fields?

       

      Thank you a lot

       

       

      Regards

      Thomas