• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Customer order analysis - showing highest and lowest 10%

R

remcos

New Member
I have an excel file posted on the link below.


http://rapidgator.net/file/751eabe92d24125f24eb7ab5f57f5886/TEST_TO_SET_LOW-HIGH_MARKER_FOR_ALL_ITEMS_IN_ONE_OVERVIEW.xls.html


I would like to create an overview as per column "J" whereby it shows the top and bottom 10% of sales prices. The goal is to compare then per customer / sales region / sales rep, etc, who is selling above and below average prices etc.


The data is currently displayed using helper columns K:R.

Unless there is an easy way to fix the array formulas to copy them down a list containing over 1000 different products and >10000 sales order lines annually, this is not going to work due to the fact that each cell (currently) would have to be entered as array.


Is there a quick and easy way to fix this?


Any help is appreciated greatly.
 
I can't access any uploaded files, so I haven't had a chance to see your file, but have you considered using a PivotTable with it set to show the top/bottom 10%? Using a PT is often a quick way to get results from a large data table.
 
Hi remcos,


When i tried to download your file, it was an .exe one!! I agree with Luke, try Pivot Table.


Faseeh
 
Hi,

thanks for your help. I was expecting a notification when comments arrived, but I must have missed a trick somehow, hence the delay in responding.


I am really surprised that you are getting a .exe extension. I just tried the dowload link and it seems to work fine on my PC.


I have tried using a pivot table to get the data I wanted, but doesn't really display the information I want to see, which is why I'm trying to get it to work by using a formula.


I there another way of getting the data, or screen shot to you?

Remcos
 
Hi Faseeh ,


Check the file here :


https://www.dropbox.com/s/fgxyw9qccz8f58c/TEST_TO_SET_LOW-HIGH_MARKER_FOR_ALL_ITEMS_IN_ONE_OVERVIEW.xls?m


Narayan
 
You must log in or register to reply here.
Back
Top