1 Reply Latest reply on Jun 1, 2016 6:11 PM by Brad Shuel

    How to cross tab with Headers & Sub Headers?

    madala krishna

      Hi,

       

      I have a fields like a,b,c,d,e,f etc.

      my requirement is i want to show that information in the following format.

       

      a,b, and C Columns should come under Header 1 like this.

       

      Header 1 Header 2
      ABCDEFGH
      abcjkmountainforestschoolabdhelo12
      bcdlkkeepingclosinggoingkfcmkn23

       

      Can any one help me. Please find the sample workbook (V 9.1)

       

      Thanks,

      Madala

        • 1. Re: How to cross tab with Headers & Sub Headers?
          Brad Shuel

          Hello Madala,

           

          We may need to create separate sheets for the headers and combine all 3 sheets on one dashboard.

           

          1. Create the calculated fields "Header 1" and "Header 2".

           

          2. Create separate sheets for each header and place the calculated fields on the Marks card on Text.

           

          3. Combine all the views in a Dashboard.

           

          I have attached a copy of the workbook with my work.

           

          As an alternative, if the dimensions are related, it may be worth looking into pivoting.

           

          Hope it helps!