Ben_Gilbert Member

Hi I want to add another variable to the above equation but can't get it to work. In my Excel days I would use an IF statement. Here is my equation: when 'primary class' = 'supermarkets and gocery stores' THEN sum(case when `Split answer` = 'Female' then `Value` else 0 end) / sum(`Value`) Thanks Ben

Hi Colemen It isn't working for me, see screen shots attached. The reason why I use a line chart is because it is an industry-standard way of presenting the difference in male/female management roles on a seniority basis. ANy help appreciated. BEn

thanks for that. I did as you outlined and it almost gets there! See screenshots. The only values that weren't in order were the Senior Manager and Other Manager (which should be in each other's position). Any ideas?

Thanks @MichelleH - how do I chart these two created series as lines with the y-axis being 0%-100%? I can see the chart 100% Stacked Bar that does it for bar chart but I can't find the 100% line bar?

thanks Mark - really appreciated and will check out the resource you listed.