show top row in straight table according to measure

[aheavy95]

Hi
In this dynamic report (ad hoc report) Im trying to get only the top row in the staright table.
There is a constant dimension - Store name, and the other 2 dynamically change according to user's selections in the upper filters through'=SubStringCount(Concat([Float1.Num],'|'),01)' ). The measure can change as well.

I have tried using dimension limitation,  but I get 'Others' in the year dimension somehow: 

For example, in this case the top row only should be shown. 

Thanks

[L_Hop]

Hi,

you should apply aggragetions, below aggregations may work.

max(aggr(sum(your_maeasure_field),year,half_hour,store_name))

regards.

[aheavy95]

I assume it doesn't work, I get the same result since it is calculated per row