+ Start a Discussion

Matrix Report - calculation based on picklist values

Hi Team,

I am working on building a opportunity matrix report which would show picture of quota, pipeline and target achieved.


We are using custom build forecast function and hence we are not able to use the standard forecast reports. We have 5 stages in opportunity cycle and also created a opportunity record type with 6th stage value as quota to assign quota for all salesrep. SO here is what i am looking for. The matrix report i am using is first grouped by sales rep and then by stage. so for each sales rep, the report shows the numbers by each stage (stage 1 to stage 6).


Now i would like to add some calculation, for example stage 6 - stage 5 (quota - closed won) and it should show the number for each sales rep and then finally the overall one. is it possible to configure without custom coding?