2 Replies Latest reply on Nov 15, 2012 5:20 AM by Ranjan Sahoo

# SORTING in one column through one agregrated data.

Hi Team,

I have five columns, I am trying to sort the data based on a measure, but trouble i amm facing when i am sorting say on column 1(initative name).

It is forming a group(initative name has 5 markets, it is bringing all 5 markets) then sorting, in effect it is brinnging some smaller value.I want only sort based on individual rows.

example-

Initaitive name market  revenue

I1                     m1       100

I2                     m2        90

I2                      m3       8

I3                     m3        85

I don't want the row I2 m3 8, can i do sort on composite ley something or any other solution to avoid the row.

Thanks,

Ranjan

• ###### 1. Re: SORTING in one column through one agregrated data.

What is your criteria for removing the row? Or do you just want it further down the list?

• ###### 2. Re: SORTING in one column through one agregrated data.

Hi Alex,

I am not getting the reply mail. So i was confused. sorry for late reply.

The criteria is initiative i+m should be the criteria to sort. but now it is sorting based on i only.

say if i have initaive list of i1 having with m1,m2,m3,m4 combination as 200(say i1+m1=40,i1+m2=60,i1+m3=50,i1+m4) and i2 and m5 combination as 150.

Then with wort it is returning as

i1      m1     40

m2     60

m3     50

m4     50

i2      m5     150

Here the sort I2 should come top then i1 should come.

The whole objective is to sort based on individual rows of i and m. It is sorting i as a group.

Please let me know if you need more clarification.

Thanks,

Ranjan