Introduction to Sorting

Sorts are a means of sequencing your data in a way that is most meaningful to you. Descending and ascending sorts can be applied to a level, an attribute relationship for a level, a measure item, or totals. You can combine sorts with filters to achieve a view of data that best fits your particular business needs.

Alphanumeric Sorts

Stratum.Viewer will sort non-calendar based objects alphanumerically. This view has an ascending sort on the first measure item.

The next view has a descending sort on the Region level in columns and ascending sort on the UPC Long Description attribute relationship in rows.

Calendar Based Sorts

Stratum.Viewer will sort calendar based objects according to their calendar order. Calendar based objects are objects related to time, such as a Year or Months time level. In this view, descending sorts exist on the Year Based level in columns and Months level in rows.