Hey! I have seen many questions about this topic here but i couldn't solve my problem. Here i go, i have an excel that has vendors and goals left join to a sql source that has vendors and sales amount, i want to show the vendors, his goals, the sum(sales) and the sum of the goals but i have three problems:

1. The goals duplicate per each vendor sale. I used Attr(Goals ) but then i couldnt add a Total or Subtotal

2. The goals doesn t show for the vendors that doesn t appear in the sql data sources. I want to see the goals of the vendors even if they havent made any sale yet

Thanks!