2 Replies Latest reply on Oct 13, 2018 8:20 PM by PAULA CASTILLO

    Excel and Sql data sources

    PAULA CASTILLO

      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!