Max of one field based on max of another field at script level

[GianluigiBI]

Hello guys,

as you can see I have a table similar to the one in the screen.
I would need an additional table created like:
Distinct of the Stores; Select the max of the cycle, and I would need the Prog value associated with the max of the cycle

[Lisa_P]

This is possible with the following configuration in a table:

Dimension 1: Store
Dimension 2: aggr(Max(Cycle), Store)
Measure 1: Max(Prog)