U
user3307
hello,
I have the following database:
item item spend responsible
1 200 peter
2 400 jack
3 50 peter
4 2000 julie
etc.
each person is responsible for a number of items and thus a total spend.
I would like to create (ideally) a pivot which shows a pareto on spend and
number of items (e.g. Peter's complete spend is 23500 on 42 items, 80% of his
spend is on 7 items, 80% of his items amount to a 40000 spend).
Can anyone please tell me how to do this?
Thank you very much in advance!
E.
I have the following database:
item item spend responsible
1 200 peter
2 400 jack
3 50 peter
4 2000 julie
etc.
each person is responsible for a number of items and thus a total spend.
I would like to create (ideally) a pivot which shows a pareto on spend and
number of items (e.g. Peter's complete spend is 23500 on 42 items, 80% of his
spend is on 7 items, 80% of his items amount to a 40000 spend).
Can anyone please tell me how to do this?
Thank you very much in advance!
E.