I seem to be experiencing some strange behavior with the Dimension Limitation and Stacked Bar Chart.
I have the below table. My dimensions are Month Year and Sector and my measures is sum(Fabs(Value))/sum(Total <[Month Year]> Fabs(Value)). In my table I have a dimensional limit on Sector to show Top 4 and others.
If I then drag a bar chart over the table I get the following.
However if I choose to stack my dimensions in the bar chart vs group the calculation is erratic and wrong.