Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Harleen,
You have to set the dimension limits on both the dimensions ( Dim1 and Dim 2)
Regards
Satheesh
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
Hi Harleen,
Set the dim 1 limit to largest 3 and the dim2 limit to largest 1
Regards
Satheesh
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