4 Replies Latest reply on Aug 16, 2016 5:35 PM by Brad Gaston

    Max calculation that Operates without the dimension in the view

    Brad Gaston

      I have a data set that looks like the following:


      I want to calculate the Max headcount by business.  I can bring in Business Name onto Rows then Headcount onto Text, finally changing the Grand Total to compute the MAX.  However, I want to create a view that just shows the Max headcount.  Essentially,


      From this....


      To something like this...



      Unfortunately, I cannot determine the syntax in a calculated field to return the desired result.   Does anyone know how to accomplish this?