I need to display a chart which shows total within categories. For example, below is the chart that I wish to display:
I tried using the Totals option in the analytics tab. But the result that I am getting is given below. The total data is getting summed across male and female.
Is there any way of getting the first view pasted on top. I have attached the dummy tableau file.
I would appreciate any help.
If you want that format you could create separate measures for each bar then you can arrange the bars however you want.