Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a Straight Table where I have categories per employee. I have 1 column CATEGORY and several values for this column (Category 1 a, Category 1 b, Category 1 c, Category 2 a, Category 2 b, Category 3 a, Category 4 b, Category 4 c etc).
I need to show all the values but only of the highest category per employee. Category 1 being the highest and Category 6 being the lowest category.
Have you ever had a case like this?
Hi,
Check this function: FirstSortedValue
I found this function, yes, but I don't know how to implement it in my case because it is an aggregate function and here I have string values.
Not sure what You expect but maybe this will help (make a table with this 3 columns):
Employee, firstsortedvalue (CATEGORY, mid(CATEGORY,10,1)), firstsortedvalue (CATEGORY, -mid(CATEGORY,10,1))
Do You want to get 2 columns? Employee, Category (only min and max).
I need to show only the highest Category, for example if an employee has values for all categories I need to show only Category 1 values, if Category 1 is zero then I need to show all values of Category 2 etc....