Report to show accounts with opportunities **for each specific product** for previous year but not this year

Question

Ideally, I'd like a clear view of all non-renewals per account. This would be product specific.

I.e. Where opportunity product code "A" appears on one account for 2013 but not 2014, show the original opportunity and account name.

Any help would be much appreciated

Deepak K Anand · Accepted Answer

No doubt! @SteveMo(_img alt="User-added image" src="https://success.salesforce.com/profilephoto/72930000000cTXU/F" /_) is your go to report guy :)

Not sure, are you looking at something kinda like this:

If so, I would suggest you to take take look at the Opportunity Product Report and then repurpose them same like as above:

Jo Green · Answer

Thank you Deepak! Will have a go with this and let you know how I get on

Report to show accounts with opportunities for each specific product for previous year but not this year