Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can't sort RunningSum metric by Custom Group

Status
Not open for further replies.

JRO061601

MIS
May 30, 2002
92
US
I keep running into the problem outlined in TN5700-72X-1001. I want to create reports using Custom Groups that show Cumulative Frequency (using the RunningSum function), but the metric is not calculated in the order of the Custom Group. Anyone else run into this and figure out a workaround? Thanks.
 
Hi ,

I ran into the same problem. Running sum did not calculate based on the custom group elements. You could try this


Create new metrics M1 = max (1)
M2 = runningsum(M1)

If the runningsum metric you created is M3. Now in runningsum parameters choose sort by objects...and select M2.
In your report you will need to include metric M2.I was creating a graph so it did not matter to me.
your report would look like

Custom grp M2 M3

A 1 5
B 2 10

Hope this helps.


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top