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?
Almar van Pel