Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
What is the best method for summing data records into bands ? In the script ? Or in set analysis ?
I have thousands of transactions of sales data made up of the following fields....
Sale ID
Date of Sale
Sale Amount (in £)
Salesperson
I want to create a simple bar chart showing the number of salespersons ('Y' axis) who have a total sales figure between £0 and £100,000; between £100,001 and £200,000; between £200,001 and £300,000....and so on, in groups or bands of £100,000. The bands will appear on the 'X' axis.
So, for example, Salesman A who has sales of £650,000 will count as 1 salesperson in the £600,001 - £700,000 column band of the chart.
How should I approach this?
Your advice is much appreciated
MV
or by precalculating sequential buckets values for the same field in the script
regards
Marco