Pie Chart data display.

[#1]

Hi,

Can some one help me in solving my requirement.

I have a pie chart which displays country wise top 10 sales records. I want to display the records based on decreasing order of sales.

Attached Image for reference.

Thanks in Advance.

[PrashantSangle]

Hi,

Go to sort->expression -> Write Expression -> Desending

Regards

[veeranj]

Hi,

Go To Dimension limits and set  show only(largest) to 10 values.
Now go to Sort and  write the expression over there and select descending option.

Thanks

Anjee

[#4]

Thanks for your reply.

I have set those properties but its not working.

[#5]

Thanks for your reply.

I have set the dimension limits . What expression do i need to write in sort?

[swuehl]

Either use sort option 'y value' and descending in sort tab, or try repeating your expression on expression tab also as sort expression in sort tab.

Something like

=sum(Sales)

?

It would make things a lot easier if you describe what settings you are using in your chart, i.e. which dimension, which expression, and other options you've set.

At best, post a small sample QVW.

[#7]

Hi Swuehl,

Thanks for your reply.

I have one dimension i.e Country, one expression i.e Sum(Sales) and selected the relative option. In Sort tab for Sum(Sales) i have selected the descending option and for country i have selected the order as A-Z. But it is not showing in descending order of their percentages.

Do i need to write any expression in Sort?

[swuehl]

Not sure where you've find the sort tab for your expression.

Disable the text sort order for your dimension.

Enabling the sorting the dimension by Y-value descending should do what you want.

Alternatively, use the sort by expression sort option with sum(Sales).

[#9]

Thanks Swuehl.

Now i got it.

[pratap6699]

dimension limits-->display 10

sort-->sum(sales)

expre-->sum(sales)