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

    Trailing Grand Summary Sort different then SubSummary?


      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!