6 Replies Latest reply on Oct 24, 2017 10:17 PM by Kylie Kaye

    Colour Coding Aggregate Measure by the Dimensions used

    Kylie Kaye

      I have created a calculated field that sums a number of measures (e.g. Profit + Quantity + Sales) and used it to create a column chart by one dimension (e.g. State). I now want to colour code those columns (i.e. create a stacked column) by the individual measures that make up the aggregate field. See attached workboook - Tab 1 shows the aggregate measure by a single dimension. Tab 2 shows the kind of stacked column I want to get to (included to illustrate layout/format *only* (I don't want to use these measures/dimensions).

       

      Grateful for any help!