3 Replies Latest reply on Jan 22, 2018 2:16 PM by Deepak Rai

    How to not nest Rows in Text Table

    David Matthews

      Hello in advance

       

      I am looking to reproduce an excel report and am unsure of how to do something in Tableau. Hoping it can easily be done and perhaps someone can point me to a video or something online showing how to do it.

       

      Sample data would be as follows

       

          

      Primary KeyNumcountRegionFlag 1Flag 2Flag 3
      11165NEYNN
      22247WENYN
      33337SOYNN
      44437NEYNY
      55579SONNY
      66627WEYYN
      77787WEYYY
      888765NENYN
      99978SONYY
      23444NENYN

       

      In tableau it seems I have to nest the Flags in Rows which is what is done in the excel report. How can I get it so that the flags are underneath each other like the pic of the sample I have below. So flag 1 and the sum of numcount are first and then underneath the sum of numcount for Flag 2, Flag 3 etc.

       

       

      This is a example of what the excel report would looks like. Has sum by region for flag 1, then flag 2 under it,

       

        

        

      FlagsNEWESO
      Flag 1 Y10211437
      Flag 1N809470
      Total91116137
      Flag 2 Y4416178
      Flay 2 N1020116
      Total146161194
      Flag 3 Y3787157
      Flag 3 N8747437
      Total911161194