Dimension limits problem

[#1]

I am using two dimensions and one expression

I applied demension limit to show Largest 1 value. It is sorted on the bases of first expression(hours)

But it is showing result like this

Dim1     Dim2     Hours

3526     july          4000

3526     Aug          240

3526     Jun               16

But result should only show the first row. How it is possible?

thanks

[#2]

Hi Harleen,

You have to set the dimension limits on both the dimensions ( Dim1 and Dim 2)

Regards

Satheesh

[#3]

Satheesh,

                   i have applied that. But again when i increase dimension limit to "largest 3".

It is showing 9 rows

but i noticed it is showing 3 unique Dim1 repeatedly

Resource No	Month Year	Hours
		1727628
3526	Jul-2012	40080
3554	Sep-2012	24883
3468	Aug-2012	19826
3468	Sep-2012	12773
3554	Jun-2012	504
3554	Mar-2012	494
3468	Apr-2012	253
3526	Aug-2012	240
3526	Jun-2012	16

Thanks

[#4]

Hi Harleen,

Set the dim 1 limit to largest 3 and the dim2 limit to largest 1

Regards

Satheesh

[#5]

yeah satheesh,

                                it worked but i don't care about the restrictions based on dimensions. What i have read about dimension limits is that it should always show top N values based on first expression not on the bases of Dimensions.

so that whole straight table should show largest values based on Expression

thanks