Question:
Hi to all,
I just want to count a number of outlets a distributor have in one query.
Levels:
region may have several distributors
distributor may have several outlet
outlets have sales value.
But i dont need to display all outlets drilled down, only a number of outlets with sales will be displayed in the distributor, and in region.
Can u help me pls. Thank.
dennis
Answer:
did you try already with a calculated key figure?
Answer:
Depending on your BW version :
If 2.x, Look in SAPNet , there is an how-to guide.
If 3.0, there is a special exception aggreggation, counting occurrences.
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
"Check for : "How to...Count the occurrences of a characterisitc relative to one more other characteristics".
Used it in 3.0 and works perfect.