2 Replies Latest reply on Dec 28, 2016 7:46 AM by Paul Auen

    Table calculation sorting inconsistency with date hierarchy

    Neil Berkowitz

      This is a duplication of a question I posted in a less complete form yesterday.

       

      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.

      FY Only.jpg

      Works great until somebody drills down to quarters or months (or lower, presumably), which no longer sort descending.

      FY and Qtr.jpg

      Note that I've attached the two image files in case they are not clear above.

       

      Thanks.

       

      Neil Berkowitz

      Seattle Children's Research Institute