zcust_group related issue

[rizwana_khan1]

HI

in a report the data is displaying like this

ZCUST_GROUP   ZAMOUNT

000122                  10000

000123                   2900

MARK                     40000

TUBA                       400000

AMITH                    38900

The user wants to see the names of the groups first then the numbers.what we have done is we just sorted it.and shown the names first and then the numbers.

ZCUST_GROUP        ZAMOUNT

MARK

TUBA

AMITH

000122

000123

But now my user wants to see the names first starting with A and in order

could you plz help me to resolve this issue,As from the suggestions i came to know like this will be possible through abap logic.How to do it?

thank u,

[anshu_lilhori]

HI,

One suggestion only if you have few customer groups.

Add one navigational attribute to customer group and fill the data in it manually based on the order you need

AMITH----1

000122---2

000123----3

So on based on the order.Keep this navigational attribute in rows before any other char (Means it should be the first one under rows )

As far as i understand sorting works from left to right.

You can try.

Regards,
AL

[Former Member]

Hi Rizawana,

This is not possible, we can sort values either ascending/descending and based on Key or Text of self or some reference characteristics. But random sorting is not possible in BEx.

Regards,

Ganesh

[RafkeMagic]

you could work around a "random" sort by creating a hierarchy...