Attached is the application with some Sample data ,
Can someone please help me getting the expected results as in Text Box... I need to get Min value out of years for a project and Min value out of Type values for a project. I can use minstring to get the earliest year , and by ranking the value and writing an expression for getting the Type value ... but i dont want these to be expression as i need to create drop downs for both of these columns to allow user selection.
Can someone please suggest how i can get the expected results by coding in the Load Script ,please note the conditions ,
One record should be displayed for each project , Year value should be min of all values per project and Type value should be min of Ranks per project
