4 Replies Latest reply: Apr 25, 2012 2:09 AM by Sunil Chauhan RSS

    Sorting difficulty

      Hi  I have some difficulties to sort a table. I created an ABC analysis, which workes fine so far. But i need to sort the data based on the revenue of each article. That means the highest revenue of an article on top. As soon as i include a calculation to add up the revenue in another row , the table is not sorted anymore based on revenue.  this is the calculation to add up the revenue: =Sum([Summe von PNV]) + if(RowNo()=1,0,Above([Accumulated Revenue]))  No matter how i set the "revenue" sorting, ascending or descending, it does not work.It is in a strange order....  regards Jan