I just want to ask, how do you determine this?
DATE ITEM QTY UNIT PRICE AMOUNT
4/1/2012 A 4 500 2,000 as 2K interval?
I mean it's in the range of 1-2k (1k interval) and 2-4K (2k interval)
do you have a Base amount so we can determine what the interval is?
Like for Example
0 2000 =2k interval
1000 2000 =1k interval
or is your base always 0? If so then you might want to try kusha's answer^^
Sorry if I understand it the wrong way