Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
can you share a sample data and the expected output ?
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