I am using the total qualifier in a measure to create a 100% stacked bar chart:
Sum(Revenue)
/
Sum(TOTAL<Week>Revenue)
This works perfectly until I add a limitation onto the "stacking" dimension (Fixed Number, Top 11 based on measure). After applying this, the numbers on the 100% Stacked version of my chart are completely different from those before adding the limitation. Has anyone experienced this before? Is there a fix?
