Hello, one and all. I am a newbie on this forum. Can anyone help me with this problem?
I am a programmer writing a sales report for sales across three web sites. The aim of this report is to focus on items which sell well on one site but not on the others. I'm referring to this as "sales disparity," which I hope is good terminology. The main thing I need is a number to sort on (a "sales disparity index") which will bring out-of-balance items to the top. The formula needs to examine the distribution of sales across the sites, and quantify the distribution in terms of proportion, without letting bulk volume influence the result at all. For example, sales of 50, 50, and 50 are completely in balance and should go to the bottom, while sales of 5, 0, and 0 are completely out of balance and should rank high. There should be a progression from most out-of-balance to least out-of-balance throughout the report. I've tried several things, but volume always seems to creep into the picture. Any suggestions?