Calculator Inputs
Example Data Table
| Entity | Previous Sales | Current Sales | Growth (%) |
|---|---|---|---|
| North | 120000 | 144000 | 20.00 |
| South | 110000 | 118000 | 7.27 |
| East | 95000 | 104000 | 9.47 |
| West | 132000 | 160000 | 21.21 |
| Online | 150000 | 177000 | 18.00 |
| Partner | 125000 | 131000 | 4.80 |
Formula Used
Sales Growth Percentage
Growth % = ((Current Sales - Previous Sales) / Previous Sales) × 100
Percentile Rank
Percentile Rank = ((L + 0.5 × E) / N) × 100
Where:
- L = count of peer growth values below the target.
- E = count of peer growth values equal to the target.
- N = total number of peer values.
The calculator also computes mean, median, quartiles, minimum, maximum, and standard deviation to give better context around the target result.
How to Use This Calculator
- Enter a target label for the team, product, or region.
- Select how you want to provide target growth data.
- Enter previous and current sales, or type direct growth.
- Choose the peer dataset format that matches your source.
- Paste peer rows into the dataset box.
- Set the preferred decimal precision for results.
- Click the calculate button to rank the target.
- Review the cards, chart, and computed peer table.
- Download CSV or PDF summaries for reporting needs.
Frequently Asked Questions
1) What does the percentile rank mean here?
It shows how the target growth compares with peer growth values. A percentile of 80 means the target performed better than most peers in the selected comparison set.
2) Can I compare teams, regions, and products together?
Yes, but use a fair comparison set. Mixed groups can distort interpretation if sales cycles, seasonality, pricing, or market conditions differ too much.
3) Should I use revenue, units, or orders?
Use one consistent metric across the whole dataset. Revenue is common, but units or orders also work when every row measures the same thing.
4) What happens if previous sales are zero?
Growth percentage becomes undefined because division by zero is not valid. The calculator skips peer rows with zero previous sales and blocks invalid target entries.
5) Why can strong growth still have a modest percentile?
Percentile is relative, not absolute. A good growth rate can still rank lower when many peers posted even stronger gains during the same period.
6) How many peer rows should I include?
More rows usually improve stability. Small datasets still work, but percentiles become more sensitive when only a few peer values are available.
7) Does the calculator support negative growth?
Yes. Negative growth values are valid and often useful. They help show where the target stands during difficult periods or declining segments.
8) What do the CSV and PDF exports include?
The downloads include summary metrics and the computed peer dataset. They are helpful for reviews, presentations, documentation, and quick sharing.