Varaiable as field in aggr

[aheavy95]

Hi
In this dynamic report (ad hoc report) there is a constant dimension - StoreID, and the other 2 dynamically change according to the user's selections in the upper filters (same with the measure)

This is my measure: 

What I'm trying to achieve is: dynamically changing the fields inside the aggr: Hour,Year based on the user's selections.

I assume it should be done using a variable but it hasn't worked for me.

I've created a varaible (Float1.Name is the inline field ) : 

and used it in the measure instead of the "Year" field but the measure showed nulls only.

if( Sum(NetSales) >= Max( total <StoreID> Aggr( Sum(NetSales),StoreID, Hour,Year) )-1,
     Max( total <StoreID> Aggr( Sum(NetSales),StoreID, Hour,$(vDynFloat1)) ),
     Null()
)

What am I doing wrong? (open to other ways as well)

Thanks 

[vincent_ardiet_ · Accepted solution]

I would say that you need to add a "=" in your variable definition, or, you can add it in the expression:
Max( total <StoreID> Aggr( Sum(NetSales),StoreID, Hour,$(=vDynFloat1)) )

[aheavy95]

That helped! thanks a lot