I have a requirement similar to this- I have a list of planned costs for different phases in a single calendar year. So this list looks like this:
CALYEAR PHASE PCOSTS
2004 P1 1,200
2004 P2 900
2004 P3 1,300
2005 P1 1,400
2005 P2 1,200
2005 P3 800
2005 P4 700
Now I have to define a query which plots these costs against the position of each cost in the value range for a year. Simply put, I'll have to find out the olympic rank of each cost data within all the cost data for each year. So, 2004 will have a range of 3 values and 2005 will have a range of 4 values.
After this I'll have to find out the max. rank for each year.
So can someone please tell me how to go about this?