Hi,
I have a nested rows
Reps and accounts and I have a calculated dataitem on my column whose expression is Count([Current Measure] within set siblings(currentMember(Hierarchy)))
So when I say sort in layout descending for my calculated data item column ,my sorting doesnt work.
It should based on my account count column value.
Ytd AccountCOunt
A 123 34 3
345 12 3
234 22 3
B 235 23 2
333 12 2
Thanks,
Nithya
Quote from: nithya1224 on 11 May 2014 07:11:03 PM
Hi,
I have a nested rows
Reps and accounts and I have a calculated dataitem on my column whose expression is Count([Current Measure] within set siblings(currentMember(Hierarchy)))
So when I say sort in layout descending for my calculated data item column ,my sorting doesnt work.
It should based on my account count column value.
Ytd AccountCOunt
A 123 34 3
345 12 3
234 22 3
B 235 23 2
333 12 2
Thanks,
Nithya
Your sorting doesn't work.....have you taken a look at the Forum Etiquette post yet? I believe it suggests that simply saying "it doesn't work" is not really providing enough information to go on.
Are you getting an error or is the behavior not what you expect? Can you explain the steps you took to apply the sorting? The example data you posted looks an awful lot like descending order based on your account count column to me. If this isn't how you want it can you show what it should be? Or if this is how you want it can you explain how it is sorting incorrectly?
The Account Count data item is not sorting in descending order.
I select the Column and choose sort by value by descending.
Its a dimensional package and I dont get any errors , column values are being sorted in random orders.
I get the result like
Ytd AccountCOunt
B 235 23 2
333 12 2
A 123 34 3
345 12 3
234 22 3
C 123 34 1
E 345 12 5
234 22 5
345 12 5
234 22 5
345 12 5
It should be sorted like 5,3 2 ,1 - E,A,B,C order.
Thanks,
Nithya
If you are sorting on the column then I believe it is sorting correctly within each grouping. Since your values are all the same within each grouping the appearance is unchanged.
What you really want to order are your rows. Try removing the sorting you applied on the account count column and instead apply sorting to your rows (whatever A, B, C etc represent).
Still my sorting doesnt work.
A,B,C are sales reps and i have nested the Accounts under them.
Now my sales rep A has 3 accounts nested under it and I will have the count value in the Account column.
Now the sorting done on No of accounts (descending).
First i tried Sorting on Account Column - Sort descending by value - dint sort .
I removed the sorting and gave layout sorting on the sales rep - it dint work. I also gave layout sorting with sales rep and chose Account column and Set sorting order as descending.
Then I thought since accounts are nested,we should sort that one, so I also tried the layout sorting on the nested row that is Accounts with descending order on Account count.
My result looks like this
A ABC001 345 2
ABC002 456 2
B BAsdd0 231 1
C CAsfd1 234 7
CAsfd2 234 7
CAsfd3 234 7
CAsfd4 234 7
CAsfd5 234 7
CAsfd6 234 7
CAsfdd7 234 7
Expected Result:
C CAsfd1 234 7
CAsfd2 234 7
CAsfd3 234 7
CAsfd4 234 7
CAsfd5 234 7
CAsfd6 234 7
CAsfd7 234 7
A ABC001 345 2
ABC002 456 2
B BAsdd0 231 1
Thanks,
Nithya
Hi ,
Any help on this issue, I have tried almost all methods in sorting..but couldnt make it working..
Used Order() method, used layout sorting.
Sort by value option is not coming for my data item.May be is this an issue.
I tried with a nested rows and one column which is not calculated and it showed sort by value option.
but now the dataitem which I am using Count([currentMeasure] within set siblings(currentMember(Hierarchy))) ,when I select this and say sort,it shows only sort by label option.
Is there any work around to fix this .
I appreciate your help.
Thanks,
Nithya
Thanks,
Nithya