My data is organized below and I would like to make a bar graph with the dimension being Company and the graph will show the distribution of gender (Male/Female) for each company. (e.g. For A, it will show two bars, first bar is 40% for Male and second bar is 60% for Female) Is this possible to do it inside set analysis? I don't want to create a separate table from the main one.
All help and feedbacks are appreciated! Just let me know if you guys need more details.