3 Replies Latest reply on Jan 20, 2019 6:53 PM by ruth.wyer

    Excluding Total Colour when using calculated field

    ruth.wyer

      Hi everyone,

       

      I know you there are ways around exclude colour from totals when you are using heat maps or measure values on the colour shelf, however, I am using a calculated field to determine whether a target has been met or not.  The targets are different for each group so does not make sense as a total but I can't figure out how to exclude it.  The total line is a combination of 4 groups in the Bu Group (there are more BU Groups, only 4 are used in total) so the 'Shrinkage Target by BU calc is not working for total as each of those 4 groups are selected in the filter so I'm assuming it meets the first condition.  Is there a way to exclude the total?

       

       

      Thanks in advance

      Ruth