I have requirement where in i have 2 metrics in ROWS and Month dimension in column. Now i selected 4 values in the filter,
The first measure (Profit) is a bar graph and second measure (Quantity) is a line graph, with dual axis. My requirement is i need Quantity as a line graph which i am able to achieve, but when it comes to bar graph it is becoming as stacked bar graph, what i need is i need two bars side be side for each month.
Attached is work book with sample data and also attached is a screen shot of what i am trying to achieve.