BI Publisher chart question

Nimeshmaheshwari

Summary

BI Publisher chart question

Content

Hello,

I have a bar chart broken down by US/Non-US stacks going across years. I need to add inside the bar showing year on year growth starting from second year. How can i do that in OBIEE Publisher?

Below is the xml:

<Graph seriesEffect="SE_AUTO_GRADIENT" graphType="BAR_VERT_STACK"><LegendArea visible="true" automaticPlacement="AP_NEVER" position="LAP_TOP" /><Title text="Commissions (USD mill)" visible="true" horizontalAlignment="CENTER"><GraphFont name="Arial" size="10" bold="true" italic="false" underline="false" /></Title><LegendText><GraphFont name="Arial" size="10" bold="true" italic="false" underline="false" /></LegendText><O1Title text="Year" visible="true"><GraphFont name="Arial" size="10" bold="true" italic="false" underline="false" /></O1Title><Y1Axis><ViewFormat scaleFactorUsed="true" scaleFactor="SCALEFACTOR_NONE" /></Y1Axis><SeriesItems><Series id="0" color="#003A6F" /><Series id="1" color="#00889A" /><Series id="2" color="#E68300" /><Series id="3" color="#88002B" /><Series id="4" color="#76B8E7" /></SeriesItems><Y1TickLabel><GraphFont name="Arial" size="10" bold="true" italic="false" underline="false" /></Y1TickLabel><O1TickLabel><GraphFont name="Arial" size="10" bold="true" italic="false" underline="false" /></O1TickLabel><LocalGridData colCount="{count(xdoxslt:group(.//G_4,  'SAW_0'))}" rowCount="2"><RowLabels><Label>US</Label><Label>Non-US</Label></RowLabels><ColLabels><xsl:for-each-group select=".//G_4" group-by="SAW_0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"><Label><xsl:value-of select="current-group()/SAW_0" /></Label></xsl:for-each-group></ColLabels><DataValues><RowData><xsl:for-each-group select=".//G_4" group-by="SAW_0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"><Cell><xsl:value-of select="sum(current-group()/SAW_1[.!=''])" /></Cell></xsl:for-each-group></RowData><RowData><xsl:for-each-group select=".//G_4" group-by="SAW_0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"><Cell><xsl:value-of select="sum(current-group()/SAW_2[.!=''])" /></Cell></xsl:for-each-group></RowData></DataValues></LocalGridData></Graph>