Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Darrell,
You can try this: As you are using a Text box, Goto Properties-> Caption Check the box Show Caption and in the Title Text box type =COMPETITOR (this would be your actual competitor field name). By doing this, it will get you the competitor name as the heading for your Text object. Hope that helps.
ANDY
Probably something using the firstsortedvalue() function. Maybe something like this?
firstsortedvalue(Competitor,-max({1<[Month] = {"$(=max(Month))"}, [Market] = {"Milk"}, [Company] -= {"First*"}>}PPL))
I probably have a mistake there. But the intent is that it would, for each competitor, calculate the max value paid out by that specific competitor. Then it sorts those in reverse order (the minus sign), putting the maximum of those maximum values first. Then it takes the value of that competitor.
You might also have a look at the rank() function.