+ Start a Discussion
kevinvw2000kevinvw2000 

Matrix report with year to year difference and percent

I want to create a matrix report for sales by sales person by year.
The sales people would be down the left side and the years would be columns across the top.
Assume (based on the data) that the year columns across are - 2010, 2011, 2012, 2013, 2014
After the 2011 column I would like a column that shows the difference between 2011 and 2010.
Then after the 2012 column I want to show the difference between 2012 and 2011.
After 2013, show diff between 2013 and 2012.
etc. etc.

Does this sound like a custom visual force page?

Thanks, Kevin.
 
PratikPratik (Salesforce Developers) 
Hi Kavin,

You can create a matrix report and group date value by year so you can get 20011, 2012 etc. columns.
I don't think you will be able to add additional column to have difference between 2 years.

Thanks,
Pratik