9 Replies Latest reply on Nov 6, 2018 2:53 PM by Justin Dean

    Adding color dimension to my chart changes table calculations

    Justin Dean

      Hello, I am trying to create a horizontal bar chart tracking YOY growth for office using employment in different cities. I have figured out how to do this with table calculations fairly easily.

       

      However, when I try to add a color dimension to show how each sector is fueling growth for office using employment, it calculates the growth of each dimension and sums them together on the bar. I've searched for a while and can't find a way around this.

       

      In the attached workbook, sheet 1 shows the correct calculations without colors and sheet 2 shows the colors but incorrect calculations.