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

    SORTING in one column through one agregrated data.

    Ranjan Sahoo

      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.
          Alex Kerin

          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.
            Ranjan Sahoo

            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