re: What's the code ?
Hi,
I have the following sales data which I want to analyse sales-person wise. Our company traditionally sells oranges & apples and has now diversified into selling other fruits. I would like to analyse the sales person wise sales into traditional sales (Oranges &Apples) in one column and rest of brands put together in another column.
I tried but I'm getting stumped in the code ? Pls help ?
Thanks,
Ash
SALES PERSON BRAND SALES
ALAN ORANGES 12
ALAN APPLES 22
ALAN BANANAS 37
ALAN LEMONS 17
ALAN PEACHES 7
ALAN PINEAPPLES 32
MIKE ORANGES 7
MIKE APPLES 9
MIKE BANANAS 27
MIKE LEMONS 32
MIKE PEACHES 34
MIKE PINEAPPLES 42
SMITH BANANAS 12
SMITH LEMONS 12
SMITH PEACHES 22
SMITH PINEAPPLES 22
Hi,
I have the following sales data which I want to analyse sales-person wise. Our company traditionally sells oranges & apples and has now diversified into selling other fruits. I would like to analyse the sales person wise sales into traditional sales (Oranges &Apples) in one column and rest of brands put together in another column.
I tried but I'm getting stumped in the code ? Pls help ?
Thanks,
Ash
SALES PERSON BRAND SALES
ALAN ORANGES 12
ALAN APPLES 22
ALAN BANANAS 37
ALAN LEMONS 17
ALAN PEACHES 7
ALAN PINEAPPLES 32
MIKE ORANGES 7
MIKE APPLES 9
MIKE BANANAS 27
MIKE LEMONS 32
MIKE PEACHES 34
MIKE PINEAPPLES 42
SMITH BANANAS 12
SMITH LEMONS 12
SMITH PEACHES 22
SMITH PINEAPPLES 22