AnsweredAssumed Answered

Trailing Grand Summary Sort different then SubSummary?

Question asked by gremlin9297 on Oct 7, 2016
Latest reply on Oct 7, 2016 by 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!

Outcomes