Need to create a chart where Region values are America, Europe and Asia but the requirement is to show another value which is the sum of all three as Overall. Any suggestions ?
Would be it be better to solve it in the script or the object level ?
For getting total with all the dimensions.
Go to Dimension Limits, refer the image attached below(Total.png).
Then on Expression - > Background Color - > =if(Region=Region,rgb(80,160,240),rgb(252,115,98)).
Kindly refer the attached image, I have disabled the Dimension Name but with blue color shows region(like america, india etc) and red color shows(total_d).
Kindly refer the attached QVW file.
Here you'll find the solution of your requirement.
Also follow the steps defined in previous post of mine, to made this chart.
Hope this will help you to get the desired result.