Report on MM

[Former Member]

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

[Former Member · Accepted solution]

I think you can group in the same way.

But to create ranges you can do that seperately for e.g.

Select Material and bring it into Rows

Right click and hit edit

Then in edit Restrict the Material and hit Interval ranges

Select 1 and then 10

Similarly repeat for 10 to 20 (U need to bring material again and again restrict it with different values.)

I hope you are clear how to do grouping so that is not the issue.....