Skip to Content
0
Former Member
Aug 30, 2005 at 09:29 AM

categorising vendors

15 Views

Hello All,

I'm looking for a way in the bex or web to report vendors divided into different turnover category's.

What I have is an infocube containing a couple of characteristics including vendor and a key figure called invoice value. This infocube contains all purchase invoices.

What I want to do is sum the invoice value and devide the vendors into groups:

category no vendors total invoice value

turnover < 0 euro 16 -12.343.45 euro

turnover < 10000 euro 57 64.234.87 euro

etc etc etc

My problem is that I'm unable to summarize the value and then count the vendors so that they appear in the right category.

Has someone tried this in the BEX or WEB with a variable time selection?

Best regards,

Almar van Pel