Chart (pivot table) sort by expression ignoring zero's (null?)

[guyvermeiren]

Hello,

I have a pivot table with several expressions and one dimension. Now I want to sort 'descending' one of the expression-columns.

The problem I get is that it shows first a number of zero values and then starts ith the highest value (see example sort / sort by Turnover 2007). Has this got to do with the fact that the zero's represent missing data ???

How can I solve this problem ??

Thanks,

Guy

[#2]

Perhaps: in presentation tab delete values null

[guyvermeiren]

Hello,

We already tried to use these options in the presentation tab.

No succes.

Kind regards,

Guy

[#4]

try sort by expression and put your expression...

are you sure that "0" is considerated as a null value?

[guyvermeiren]

Hello,

I don't exactly understand what you mean. We already worked by "Sort by expression" putting in the expression.

It's at that moment that we get the the result as in the example.

First the zero's (probably the customers whithout turnover for that year) followed by the sort as it should be.

Kind regards,

Guy

[#6]

Can you post an application with this table?

[#7]

For ones that are looking for the solution:

I had a similar problem. The solution is to sort by expression and in this expression use rank function, for ex.

rank(count(id)) and sort it ascending. This will solve the problem . It worked for me.

[#8]

For ones that are looking for the solution:

I had a similar problem. The solution is to sort by expression and in this expression use rank function, for ex.

rank(count(id)) and sort it ascending. This will solve the problem . It worked for me.