Skip to main content

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_LEVEL1M12M13M14M15M16M17M18M19M110M111F112F113F114F115F116F217F218F219F220F221M222M223M224M225M226M227M328M329M330M331M332M333M334M335M336M337F338F339F340F3
4 risposte
  1. 7 dic 2018, 12:40

    Hi Avikar,

     

    You have done most of the heavy lifting, now just go to Analysis in the tool bar (above)-> Totals -> Show Column Grand Totals.

     

    Welcome to Tableau.

     

    If it solves your query please mark it as an answer.

     

    Hi Avikar, You have done most of the heavy lifting, now just go to Analysis in the tool bar (above)-> Totals -> Show Column Grand Totals. Welcome to Tableau.

     

    Thanks.

0/9000