sorting on a calculated data item value.

[cognos05]

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

[Lynn]

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?

[cognos05]

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

[Lynn]

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).

[cognos05]

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

[cognos05]

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