OTBI Analysis - Controlling Alphanumeric Sort - Uppercase and Mixed Case Sequence
SummaryHow to override the impact of Upper Case data that is sorted ahead of mixed case?
See attached image.
Suppliers "Adams..., Adjuster.., Advanced..., and Advantage..." are mixed case and are sequenced after "ASAP RESTORATION CORP" All Upper Case.
Is it possible to change the analysis column via formula or SQL to convert all row values to Upper Case to override the sort?