I want to calculate count and avg hrs of each type of numbers to particular .
attached excel with sample example.
can anyone suggest the way?
only some of the Type values to be shown.
Solved! Go to Solution.
thanks for simple exp; but I don't want to show in type dimesion and for that also count I dnt want to see in the straight table what is the possibility?
like below screen shot I need only order and server only. avg and count rest I dnt want to see
whatever I am showing avg for that only I want to show count and dimesion values.
I want to show one of field is null for that type values only how to write this exp?
=only( if(IsNull(Assigned), Number)) in this I need to include 'Order', 'Server'