OBIEE Line-Bar Stacked Graph, data marks issue

Thiyagu.BI

Hi Would like some suggestion on this.

Lets create Pivot table with 3 dimensions with 1 Fact like, 

Rows Section --> 2 Dimension columns and make Rows sum total After

Column section --> Fiscal Year  Column

Measures Section --> Fact column

Now Create Line-Bar Stacked Graph against this Pviot table output.

Bar Section --> Fact Column

Line Section --> Grand Total of Pivot Table

Group by Section --> Fiscal Year  Column

Vary Color by  --> 1st Dimension column

Issues:

Legends

Have to show only one Legend groups, it should not show for both bar and Line both.

Data Marks,

It should show Fact values and 2 Dimension values on stacked Bar and Line should show Grand Total value alone across Fiscal Years

Would like to show Only Vary Color by  Section --> Dimension values on Stacked bar alone. Not on the Line.