top 3 and top down sales

[AleCruc94]

Hi, 

i would like to obtain a table which shows me the activity which contributes the most on total revenues of the day (either positive or negative values..just to monitor both losses and earnings) 

supposing i want 3 activities.. how i could obtain it? 

thanks

[Taoufiq_Zarra]

can you share a sample data and the expected output ?

[lironbaram]

hi 

assuming your table has Day and activities  as dimensions 

you can create a measure : fabs(sum(transactions)) 

and in the activities dimension select under limitations fixed and 3 as the number of the top