6 Replies Latest reply on Aug 7, 2017 1:12 PM by Shinichiro Murakami

    Dimension Placement between measures

    Anna Warrington

      Hello,

       

      I have attached a workbook showing a test set of my work. I have CY and PY data that I use to calculate the amount and percent change YoY with calculated fields. I also have a field called 'YoY Warning Indicator' that analyzes the YoY change calculated fields I created. The warning calculated field results in an "X" or "OK" based on the change. My problem is that I have multiple amount breakdowns (sales 'total', ordinary sales, and other sales) and I want a warning indicator field following the % change fields for each sales category. I cannot figure out how to get the warning fields (dimensions) positioned between the measure fields. I tried making the warning field binary and that worked, but it isn't the ideal solution.

       

      Thank you for the help!

      Anna