0

I would like to represent in a graph the percentage of A, B and C customers in each business unit, taking into account the size of the BU (on the X axis).

         Sales      % A      % B      % C
        (kUSD)     Cust     Cust     Cust
BU A    1 000       10       50       40
BU B      100       40       40       20
BU C      500       20       30       50

Can you help me?

Improve this question
1
  • What exactly is the problem? Did something not work?
    – user201262
    Commented Oct 31, 2013 at 16:15

1 Answer 1

Reset to default
0

The easiest way is to create an intermediate table where each Customer Pct is weighted against the Business Unit Size giving you the graph you need:

Chart

Improve this answer
2
  • Thanks for your help, but I was not clear enough.
    – F. DE VOS
    Commented Nov 4, 2013 at 9:56
  • No problem, if you still need this clarify it and i'll (and lots of others) will give you a hand.
    – Rostol
    Commented Nov 4, 2013 at 18:05

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .