3 Replies Latest reply on Jul 10, 2018 5:36 AM by Hamza Alsalman

    tableau merging fields

    Hamza Alsalman

      I have a table that includes category and branch region. I also have another dimension that shows whether it is government or not. what I want to do is show my two categories and if my two categories of commercial and consumer are included in government I want to add up those values and create a government field that doesnt show consumer and commercial but rather the addition of the two.

       

       

      Thanks in advance!

        • 1. Re: tableau merging fields
          Ken Flerlage

          Can you provide a sample of your data?

          • 2. Re: tableau merging fields
            Hamza Alsalman

            unfortunately I cannot what i Can do is specify the dimension columns and what they include.

            For example:

            Branch Region:

            South

            Central

             

            Category:

            Commercial

            Consumer

             

            Government Flag:

            Government Account

            Non-Government Account

             

            What I need to display is:

            South Region:   Commercial

                                      Consumer

                                     Government

             

            Central Region:   Commercial

                                      Consumer

                                     Government

             

            What I have right now is:

            South Region:  Government Account:  Commercial

                                                                              Consumer

                                     Non-government Account: Commercial

                                                                                  Consumer

            Central Region:  Government Account:  Commercial

                                                                              Consumer

                                     Non-government Account: Commercial

                                                                                  Consumer

            • 3. Re: tableau merging fields
              Hamza Alsalman

              for the commercial and consumer values for government account I need to show the summation of consumer and commercial.

              for non-government account i must show the separation of consumer and commercial.