2 Replies Latest reply on Aug 21, 2018 10:11 AM by Ben Neville

    Group calculation

    Niranjan Banarjee

      HI,

       

      I have a certain Category Grouping as below.If I need only Category -C numbers to show separately.

       

      How can i go about it?

       

        • 1. Re: Group calculation
          Jim Dehner

          Good morning

          place Category Group on the filter shelf

          Select Category C in the filter

          Then build you viz with any detail you want - only the category C items are in the data - - just place the base dimension for the detail on the rows

           

          Jim

          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

          • 2. Re: Group calculation
            Ben Neville

            Use a calculation that is something like:

            IF [New/Existing/Convert Wearers (copy)] = 'Category-C' THEN [Category Group]

            ELSE [New/Existing/Convert Wearers (copy)]

            END

             

            That should return the lower level field (whatever it's called) when your group = 'Category-C', and otherwise just return the value from your grouped field.