0 Replies Latest reply: Jun 9, 2016 5:08 AM by Alan Huddart RSS

    Using the TOTAL Qualifier with Dimension Limits

    Alan Huddart

      Hi all,

       

      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?