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
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.
Thanks.