Skip to main content
Topics#Reports & DashboardsPergunta de Cara Mosier
Cara Mosier perguntou em #Reports & Dashboards
16 de mar. de 2015, 19:39

Create stacked bar chart showing the difference between actual and target amounts

I'm trying to create a stacked bar chart which shows the difference between my actual revenue and my target revenue.  There should be two sections of the bar:  The bottom section of the bar shows my actual revenue and the top section shows the difference between my actual and target.  The total target revenue amount to display at the top of the bar.  Like the far right column in this mockup ....

 

Create stacked bar chart showing the difference between actual and target amounts

 

In my report, I have a column for the actual revenue which is pulling from a field called Opportunity.OPP_A_MRC_Value__c:SUM  on an opportunity and then summed up on the report. 

 

I have another column for the target revenue which is determined by a formula on the report that looks like this:

 

CASE(FISCAL_YEAR:MAX,

 

2015,55845,

 

0)

 

I have a third column for the difference bettwen the target & actual revenue which is determined by another formula on the report that looks like this:

 

CASE(FISCAL_YEAR:MAX,

 

2015,55845,

 

0) - Opportunity.OPP_A_MRC_Value__c:SUM

 

I can easily build a horizontal bar chart with one bar showing me the actual revenue and one bar showing me the target revenue.  But no matter what options I choose, the option to create a stacked bar graph by using the "Grouped By" dropdowns are greyed out.  Any idea what I'm doing wrong?

 

Actual vs Target
2 respostas
Escrever uma resposta...
0/9000