Is there away to work with only the totals of charts? I have two charts and I would like to make a thrid which subtracts one's totals from the other's totals for 3 expressions. The Charts are straight tables with 3 expressions each and their dimensions are different. Do I use dimensionality?
Generally, all you need to do is use the same expression in a text box that you use in your charts as this will give the same effect as disregarding the dimensions. However, in your case you also need to adjust what you are summing slightly to exclude the NULLs.
if that was the expression in your chart, you should use
so you are only summing the sales values where the Region is not NULL.
See attached for your version.
(By the way, you should consider putting your expressions into variables for ease of maintenance. If you need to change them you only have to do it once!)