Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This works to give me a chart like this:
Ok, interesting - all the formatting got messed up. Hopefully it's still decipherable while I work on cleaning it up.
For the expression total, sum(Forecast) isn't 0, so it's doing a simple sum(Forecast) for the total, and thus is missing all of your actual sales data.
I'm not sure what's going wrong with your %, and for that matter I'm not even sure what your expression IS, but using this as your forecast expression might fix the %:
sum(aggr(if(sum(Forecast),sum(Forecast),sum(Sales)),Month))
I'm guessing here the same as you - if you don't have to use sum of rows, it may fix everything. The above calculates the sum of rows directly in the expression, so you should be able to use expression total, and then I'm guessing it will plug properly into your % expression.