help with TOP of a Group in a Straight Pivot

[#1]

Attached is an Image to summarise my problem. I have a summary by branch as a straght table at the top of screen. and a Detailed View summarised by operator at the bottom.

Ive been asked to put the top OperatorName by branch as a new column on the Top Table this will allow the top box to display the top (or bottom) performer at each Branch when the filter includes more than 1 branch

Obviously I havnt got a clue how to do this, sounds so simple though ?

ColinR

[#2]

Ive managed to put a set expression together as Follows:

=maxstring( {$ <DESCREPQTY = {$(=max(DESCREPQTY))}> } NameOperator )

How can I update this to replace the Max(DescrepQTY) with an expression DescrepQty*DescrepPrice I keep getting a null thats difficult to diagnose is the below synatx correct:

=maxstring( {$ <DESCREPQTY = {$(=max(DESCREPQTY*DESCREPPRICE))}> } NameOperator )

ColinR

[#3]

The syntax on that second expression looks fine, but I doubt it will get you the values you are looking for. That expression is trying to match QTY to QTY*PRICE, which won't ever happen.

One tip to resolve those null expressions, is to put the Set Analysis expression into a table chart, but don't give the expression a label. Then when the chart is rendered, the label will be your Set Analysis expression with that dollar sign expansion evaluated. You'll see something like:

=maxstring( {$ <DESCREPQTY = {2000}> } NameOperator )

As for resolving the issue, it sounds like you want:

=maxstring( {$ <DESCREPQTY*DESCREPPRICE =
{$(=max(DESCREPQTY*DESCREPPRICE))}> } NameOperator )

Unfortunately, you can't do that in Set Analysis as the left side of the Set Modifier has to be a field. Can you load DESCREPQTY*DESCREPPRICE as a separate field in your load? Sometimes, I'll use a variable and calculate the item I want to pull out and use that in place of the dollar sign expansion. Without knowing more about your data, it's hard to say what you need to do.