2 Replies Latest reply: Feb 15, 2017 10:10 AM by Maria Harmening RSS

    going up a level

    Maria Harmening

      I have a list sorted by a category with all of the hours associated with that category like this...

       

      category x     20

      category y     100

      category z      75

       

      I want to create a measure that's the percentage of the whole, so

      category/(total sum of all the categories).

      how do i go up a level in my formula to get the total sum of all the categories since it's already aggregated by category?