Group totals

[ruthhacche]

This should be easy. When I try to group my sales across a group of accounts it is adding in lines. I am using:

groupsale = calculate([sale],all(account[name]))

I am expecting just 3 lines so why does it add in the extra lines and how do I get rid of them properly? (I can filter for where sales >0 but that is not the point)

what I get

what I want

structure

 

[alansidman]

Cannot manipulate data in a picture. Please upload your samples using XL2BB.