[OBIEE 11g] Add Custom Calculated Item

Add Custom Calculated Item

Look at the Years.

 

 Look at the Years and Amount Sold.

There is no Amount for the Year 2002 but client wants zero to be displayed for that year. 

Now this is where the option Add custom Calculated Item comes handy.  
This enables us to display zero and that too at front end level. 


Right click on Year 2001 and follow the steps as shown below - Click on Add Custom Calculated Item

Label is 2002 and value is 0.

Table and graph -