Hi Saaty, As to my knowledge there is no option to set a chart which is partialy Stacked and partialy seperated. Although, there is a workarround: Option 1: Set the Bar Chart to stack. mark the Total expresstion as invisable and show it's value on chart. This way you will have all subtotals in stacked bar and Total as a number. Option 2: Use a bar chart with lines, show stack bar for Subtotals and line for Total. Hope this was clear and helpful.
Can you post a sample file? I suspect I can solve it, but I'd need to know exactly what you're after and have some sample data and your expressions and such.
Attached is one way. There might be a better one, but it works. I created a separate "Count" field with values 'Total' and 'Subtotal'. I added that as a dimension, then changed the expressions to check the "Count" and only return a value if they should be part of that bar.
If this is what you wanted, though, I'm a little confused. The total bar just seems unnecessary, as it is always the same height as the stack of subtotals. It seems like it would be more clear without it.
