i have a data set which grows and changes each day. One column is Agency Codes (more than 230) and the other is Net Revenue.
A use tabulate for analysing and the AgencyCode must be in the order of descending total NetRevenue produced by AgencyCode (I use ColSum of NetRevenue by AgencyCode formula).
Using Value Ordering in Column Properties does not work hence the Total NetRevenue of each agency is changing dynamically.
The question is: How will JMP set the value ordering of AgencyCodes ascending automatically according to the rapid changing data of Total Net Revenue?
Many thanks in advance
if you make a data table from the tabulate, sorting is just one line of JSL away.