Add a new idea Subscribe
Status Shipped
Categories Reports
Created by Guest
Created on Jan 26, 2016

RELATED IDEAS

Aha Rank sorts by VARCHAR instead of NUMERIC in PIVOT table

Howdy,

 

When sorting by Rank within a PIVOT report  it's treating the value as a string and not sorting numerically.  Hence you get the following:

1, 10, 11, 2, 3, 4, 5, 6, 7, 8, 9

  • Attach files
  • Guest
    Reply
    |     Jan 26, 2016

    Or it display like this:

    1, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 2, 3, 4, 5, 6, 7, 8, 9