3 Replies Latest reply on Sep 20, 2019 11:56 AM by Mavis Liu

    Cross Tab - Column Header

    Bruce Xie

      Hi guys,

       

      Do you have idea how to create Cross Tab - Column Header in Tableau? Basically I  create table and  want to add Cross Tab Header  for it similar like the attached image.

       

      Thanks,

       

      Bruce Xie

        • 1. Re: Cross Tab - Column Header
          Mavis Liu

          Hi Bruce,

           

          To do this, you'd need to review the structure of your data. (What does it look like?).

           

          But most likely, you'd need to create calculations and separate sheets to get the same result.

           

          Tableau is a visualisation tool so we do encourage you to utilise the strengths in visualising data is possible!

           

          Thanks,

           

          Mavis

          • 2. Re: Cross Tab - Column Header
            Bruce Xie

            Hi Mavis,

            Thanks! Is there way to create such header? Regardless of the data. The parent header across 2 columns and has 2 sub headers..

            Bruce Xie

             

                On Friday, September 20, 2019, 01:04:10 p.m. EDT, Mavis Liu <tableaucommunity@tableau.com> wrote: 

             

                

            |

             

              Tableau Community Forums 

             

             

             

            |

            Cross Tab - Column Header

             

            reply from Mavis Liu in Forums - View the full discussion

             

            Hi Bruce,

             

             

             

            To do this, you'd need to review the structure of your data. (What does it look like?).

             

             

             

            But most likely, you'd need to create calculations and separate sheets to get the same result.

             

             

             

            Tableau is a visualisation tool so we do encourage you to utilise the strengths in visualising data is possible!

             

             

             

            Thanks,

             

             

             

            Mavis

             

            Reply to this message by replying to this email, or go to the message on Tableau Community Forums

            Start a new discussion in Forums by email or at Tableau Community Forums

            Following Cross Tab - Column Header in these streams: Inbox

             

             

             

             

            This email was sent by Tableau Community Forums because you are a registered user.

            You may unsubscribe instantly from Tableau Community Forums, or adjust email frequency in your email preferences

             

             

            • 3. Re: Cross Tab - Column Header
              Mavis Liu

              Hi Bruce,

               

              It really does depend on the structure of your data. You need to have it as :

               

              Screenshot 2019-09-20 at 19.55.06.png

               

              Then you can build the below:

               

              Screenshot 2019-09-20 at 19.54.08.png

               

              However you'd need to also pre-calculate your subtotals in the data source too.

               

              Thanks,

               

              Mavis