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

# 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

• ###### Sorting difficulty

reemove all selection in sort expression for each dimension

then

check Y value

and select descending

hope this helps

• ###### Sorting difficulty

or

reemove all selection in sort expression for each dimension

then

in expression of sort tab write

Sum([Summe von PNV]) + if(RowNo()=1,0,Above([Accumulated Revenue]))

and select descending

hope this helps

• ###### Re: Sorting difficulty

Dear Sunil  thanks. What do you mean by "check Y value"?

Also I can not add an expession. That field is disabled on the "revenue" value..... :(

• ###### Sorting difficulty

in sort at the top a

Y -value sort available

which sort your expression value in ascending or descending order

and for expression when you check the expression check box then it will go enable

hope this helps