1 Reply Latest reply on Oct 18, 2012 2:23 PM by Tracy Rodgers

    Table calculation sorting inconsistency with date hierarchy

    Neil Berkowitz

      I have a grid that displays revenue totals for each fiscal year in columns, with the sort set to descending. There is a table calculation that looks at difference from the next cell in the row. Works great until somebody drills down to quarters or months (or lower, presumably), which now longer sort descending. How can we force the sort so that iit is consistent across all levels of the date hierarch?

       

      Thanks.

       

      Neil Berkowitz

      Seattle Children's Research Institute