2 Replies Latest reply: Mar 11, 2015 5:38 AM by Sebastian Schäfer RSS

    Chart inter record functions rule out sorting

       

      I would like to create a waterfall chart and need to calculate the offsets. As an important requirement, however, the chart should show the values in descending order.

       

      I narrowed the issue down to the following problem, see table. Essentially I would like QV to sort according to column 2 and consecutively calculate column 3.

       

      Product Units     Unit Offset                                                                               

       

      C         4          0

       

      D         3          4

       

      B         2          7

       

      A         1          9

       

      In QV I calculate column 3 by the following statement

       

      RangeSum(Above(Column(1),1,RowNo()-1))

       

      which yields the right values except that the above() function seems to rule out the sort order (the rows are now sorted by "Product")

       

      Maybe this is related to the bug I discovered here, but maybe somebody already found a workaround.