I would like to remove the average row when the mean for the total column is 0. For e.g. in the output below I want to delete the average row for Name = X since the average of Total column is 0. Averages are calcuated as follows - define a / analysis mean 'a' style={tagattr='format:###,###,##0.00'}; define b / analysis mean 'b' style={tagattr='format:###,###,##0.00'}; define c / analysis mean 'c' style={tagattr='format:###,###,##0.00'}; define total / analysis mean 'total' style={tagattr='format:###,###,##0.00'}; break after Name; Date Name a b c Total 02/11/2017 X 0.00 0.00 0.00 0.00 02/18/2017 X 0.00 0.00 0.00 0.00 Average 0.00 0.00 0.00 0.00 02/11/2017 Y 45.00 0.00 7.50 45.00 02/18/2017 Y 45.00 0.00 4.00 45.00 02/25/2017 Y 43.00 0.00 5.00 43.00 03/04/2017 Y 21.00 0.00 2.00 21.00 Average 38.50 0.00 4.63 38.50 Thanks for your help.
... View more