1 of 1 people found this helpful
If you could attach packaged workbook(**.twbx), this is much easier, anyways,
if abs( [std dev of value] - avg([value] ) > 1 then avg( [value]) end
Add this field to text shelf.
Please find my solution attached as well as below steps
1st, create calculation fields
2nd, build view by dragging flag into label
Hope this helps
Book1_v10.2.twbx 2.4 MB
It worked! Thank you both very much!