6 Replies Latest reply on May 12, 2018 6:27 AM by Zhouyi Zhang

    Find % of total of dimension value

    L L

      I am trying to find the percent of total of all dimension values against one dimension total without table calculations or filters I need to be able to use this in other calculated fields.

       

      So if I do this to get total sales for one segment:

      IF [Segment] = 'corporate'

      THEN [Sales]

      ELSE NULL

      END

       

      I want to get the percent of the two other segment to that total. I have included a sample workbook.