3 Replies Latest reply on Dec 7, 2018 5:04 AM by Avikar Roy Chowdhury

    Creating a summary count

    Avikar Roy Chowdhury

      Hello All,

       

      [Very new Tableau, so apologies if a similar question has already been answered in the past.]

       

      I have a data set (attached herewith) where I need to show the number of males and females by each corporate level along with the total count of population for the entire data set. I have managed the first bit, that is create a worksheet with the breakdown of the population by each corporate level. I have used the #Number of Records as column and Corporate Level as Row. To it, I have added the Gender as Mark - Colour. This is all well and good and I am representing the data on a bar chart. Where I am struggling is to the get the count of the full population on the same bar chart. Does anyone know how can I achieve it? I am not sure if it is even possible on a single bar chart area.

       

      Any help is much appreciated.

       

        

      HR_IDGENDERCORPORATE_LEVEL
      1M1
      2M1
      3M1
      4M1
      5M1
      6M1
      7M1
      8M1
      9M1
      10M1
      11F1
      12F1
      13F1
      14F1
      15F1
      16F2
      17F2
      18F2
      19F2
      20F2
      21M2
      22M2
      23M2
      24M2
      25M2
      26M2
      27M3
      28M3
      29M3
      30M3
      31M3
      32M3
      33M3
      34M3
      35M3
      36M3
      37F3
      38F3
      39F3
      40F3