Sorting Issue

[#1]

I have a chart with two dimensions and two expressions such as:

Dimension1: ID

Dimension2: Group

Expression1: Current Year Sales

Expression2 : Previous Year Sales

I have to show top 25 values based on the current year sales in the chart.

I did it by restricting Dimension limits to show largest 25 values and sorted the current year column in descending order.

But the problem is an ID A comes at the first postion as well as the 26th position in the chart. The only difference is in the Group values. The A at the 26th position shouldn't show up.

Please help!!!!

[d_pranskus]

Could you send a sample of your development?

[#3]

This seems to be expression issue and not the sorting issue. Can you check your expression in any other object like straight table or pivot.

Thanks,

Singh

[maxgro]

is dimension limit on second dim?

did you check global grouping?

[PabloOrtiz]

Hi, try to limit the number of rows with the next option: