3 Replies Latest reply on Mar 29, 2018 11:16 AM by John McGuirk

    Display most recent calculated z score measures in a crosstab

    John McGuirk

      Hi,

       

      I need to create a crosstab view showing only the most recent calculated z score value and then sort by the z score values.  The view should look like this.

       

      Z score C     -1.01

      Z score B     -1.592

      Z score A     -2.707

       

      I have tried using LOD calculated fields but I received error messages that I couldn't use an LOD on a table calculation.  I also tried using other functions like LAST and MAX with no success.  My workbook example is attached.  Any ideas would be greatly appreciated.