When I create a waterfall chart (see example below) in Quicksight, the sort order of the breakdown field is by descending order of the values - from largest positive values to largest negative values. In the example below, from 1/1/2022 to 1/2/2022, the sort order of “student” is:
- AA 9
- DD -7
- CC -9
- EE -20
- BB -30
Is there a way I can change the sort order to the alphabetic order of “student” field:
- AA 9
- BB -30
- CC -9
- DD -7
- EE -20