cancel
Showing results for 
Search instead for 
Did you mean: 

Report on MM

Former Member
0 Kudos

Hi Gurus,

I have a doubt on Grouping can anyone please help me regarding this. The issue is i displayed the vendors and many materials they are supplying like

Vendor, No.of Material

100, 5

200, 11

1000, 25

and so on....................

Now i want to group the the vendors based on materials like

Range of Materilas, No.of Vendors

1 - 10, 5

10-20, 25

>20, 45

So, can anyone help me how to display the report in this way.

Thanks in Advance,

Regards

Ramakrishna Kamurthy

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

HI ,

You have to write routine for "Range of materials".

Like the following.

If ( Material_VAL >= 1 and Material_VAL < 10 ).

Range of Material = '1'.

elseIf ( Material_VAL >= 10 and Material_VAL < 20 ).

Range of Material = '2'.

elseIf ( Material_VAL >= 20 ).

Range of Material = '3'.

endif.

While doing the report, just you place "Range of material" into rows (Select the property as "TEXT") and "Material Value in Columns. it will display value as you desired.

Thanks and regards

Rajesh.

Answers (0)