Skip to main content
I have a report which is showing closed opportunities for two years, 2012 and 2013. I need to see which opportunites were won in 2012, and what happened in 2013 with just those accounts sold won in 2012. So, I am looking to filter out opportunites/accounts from 2012 which show $0.00.

 

I would imagine I need some type of IF statement or some way to create a dependent filter. So, for example, a single filter which says "If close date equals 2012, and amount does not equal $0.00". I cannot set both statements up as seperate filters because this would only return 2012 data, and nothing for 2013. 

 

It doesn't look like it's possible to create this type of dependent filter. Any suggestions? 
11 respostas
0/9000