Sales By account in 2015 Year



Salesforce is the most popular cloud CRM with a focus on sales and support.

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