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?