Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!!!
Could you send a sample of your development?
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
is dimension limit on second dim?
did you check global grouping?
Hi, try to limit the number of rows with the next option: