2 Replies Latest reply: Dec 13, 2010 3:35 AM by s j RSS

    Pivot Table Sort Issue

      I have an issue whereby I have created a sort order 1-7 and applied it to a field, but when the sum of that field is 0, the sort order does not apply.

      Below demonstrates the correct sort order (see Tax in position 6).

      error loading image

      When a different month is selected and Tax has a 'Actual' result of 0, it is automatically placed at the top of the group list.

      error loading image

      How can I maintain this sort order at all times?