Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
reemove all selection in sort expression for each dimension
then
check Y value
and select descending
hope this helps
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
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..... 😞
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