Sales By account in 2015 Year



Salesforce is the most popular cloud CRM with a focus on sales and support. Skyvia requires Salesforce Enterprise edition or higher.

Sales By account in 2015 Year

Query Text

SELECT "Owner"."Name" AS "Opportunity Owner", Account."Name", Opportunity."Name" AS "Opportunity Name", Opportunity."Fiscal" AS "Fiscal Period", Opportunity."CloseDate", Opportunity."Type", Opportunity."Amount"
  FROM "Opportunity"
LEFT OUTER JOIN Account ON Opportunity."AccountId" = Account."Id"
INNER JOIN User AS "Owner" ON Opportunity."OwnerId" = "Owner"."Id"
WHERE (Opportunity."IsClosed" = True AND Opportunity."IsWon" = True AND Opportunity."FiscalYear" = 2015)
ORDER BY Account."Name"

Open Query