Happy new year to All,
These formula give me the total sum of all the sales. What I need is only for the totals of the customer name.
SUM(SELECT( Orders[Total Cost],in([Name],list[_THISROW].[Name])
If(isblank([Name]),0,SUM(SELECT( Orders[Total Cost], ([Name] = [_THISROW].[Name]))))
Thanks
User | Count |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |