I have created a combo chart, with 2 expressions and 2 dimensions and 2 axis. When both the expressions are enabled. The stack bar turns into a group bars, when the line expression is disabled, the other expression is shown in stack bar. The line expression is an aggregate expression i.e I am doing aggregate of one of the dimensions, where as the bar expression is just a sum.
I am expecting like the below one which is made in excel.
but I am getting like this when line expression is enabled.
How do I again aggregate the dimension 2 ( having values like An, Cr, Pr,Sa, UL) and show it in stack format. The line expression is aggregated over dimension 1( having values like Ag,Ba,Co,In).