Graph. Filter and totalize by more than one field.

[Magogar]

Hello.

I know it must be a very simple answer, but I can not find the solution. Can someone help me please?

I want to make a graph and I need to search the rows with the highest value in the "Period" field and return the average of the "Sales" field.

I have tried the following without success:

Avg (Max(Period) Sales)

Avg({$<Period={Max(Period)}>} Sales)

Period	Sales
1	100
4	150
2	200
4	100
2	80

Expected result:

Period	Sales (Avg)
4	125

[rubenmarin · Accepted solution]

Hi, can you try?:

Avg({$<Period={$(=Max(Period))}>} Sales)

$(=...) is converted before calculating the expression so at the end it executes:

Avg({$<Period={4}>} Sales)

[Magogar]

Thank you very much. It works perfect!!!