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?

       

      Thanks!

       

      Brad