6 Replies Latest reply on Oct 7, 2016 12:04 PM by gremlin9297

    Trailing Grand Summary Sort different then SubSummary?

    gremlin9297

      Hi again,

       

           Not entirely sure if what im trying to do is even possible...

       

      I have  report that the SubSummary part of the report is sorted by FUND then SSN. By using a combination of a calc and summ:

       

      c_Fraction: 1 / GetSummary (_s_Count ;SSN)

       

      s_UniqueCount: Total of c_Fraction

       

      I'm able to get the results I want.

       

      The issue comes about when I want a total count of the Unique SSN and to get this it needs to be sorted by SSN only.

       

      Is there anyway to create a separate sort order for the Trailing Gran summary to get this result or am I SOL and need to have it on a separate script?

       

      Thank you!