Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
tunoi
Creator
Creator

Top x line into a straight table

Hi guys,

i need help with one problem.

i have the following input data:

DepClientStatusIDPValue
1a1Live1100
1a1Expired2150
1a2Live399
1a3Live4101
1a4Live5102
1a5Live1103
1a6Live2104
1a7Live3105
1a8Live4106
1a9Live5107
2a10Live6108
2a11Live7109
2a12Live8110
2a13Live9111
2a14Live7112
1a15Expired388

And i want to set up a straight table in which to display only first 10 lines from it sorting by Status(live first and the expired) and after that by value descending so in my case if i select dep 1 i will have the following expected output:

ClientStatusIDPSum(value)
a9Live5107
a8Live4106
a7Live3105
a6Live2104
a5Live1103
a4Live5102
a3Live4101
a1Live1100
a2Live399
a1Expired2150

If i dont select anything i should have:

ClientStatusIDPSum(value)
a14Live7112
a13Live9111
a12Live8110
a11Live7109
a10Live6108
a9Live5107
a8Live4106
a7Live3105
a6Live2104
a5Live1103

till now I've tried with dimensional limit and/or Rank function but i didn't get the expected output. Anyone have any idea?

8 Replies
kamal_sanguri
Specialist
Specialist

have a look..

tunoi
Creator
Creator
Author

Hi Kamal,

Your example don't work as expected when i don't have any department selected(it return 11 lines instead  of 10 as expected and also value should be an expression in the straight table not a dimension.

kamal_sanguri
Specialist
Specialist

Check this..

tunoi
Creator
Creator
Author

ty again but still it's not good because if i have a new client for the dep 1 in status Expired then i will have first 11 rows as output.

PS: i added a new line into entry data so this case will be visible.

kamal_sanguri
Specialist
Specialist

I think, I have a working copy now... Check this out.

kamal_sanguri
Specialist
Specialist

Nothing selected:

Capture.PNG

Selected 1 in Dep:

Capture.PNG

Selected 2 in Dep:

Capture.PNG

tunoi
Creator
Creator
Author

Thanks again for trying but still that wont work because that data are some mock up data. The actual dates are more complex and i have multiple lines for each combination of dimension. Also the dates have a temporal dimension, some selection will be done on that temporal dimension and some client will not have values in that period so sorting the dates in script and adding that rowno will be useless.

The solution if any exists have to be doable only in interface.

Regards,

Ionut

antoniotiman
Master III
Master III

Hi Bostan,

see Attachment.

Regards,

Antonio