100% stacked bar chart with Average expression

[Eshwar1]

Hi All,

i have created 100% stacked bar chart with below expression and dimension

dimension: Branch_code

Exp: Sum(Value)/Sum(Total <Branch_code>Value)

its working fine as expected.

and i created one more bar chart  to find out the "last 3 months average value" with using below expression

Sum({<MonthYear={">=$(=Date(AddMonths(Max(MonthYear),-3),'MMM-YYYY'))<=$(=Date(AddMonths(Max(MonthYear),-1),'MMM-YYYY'))"}>}Value)/3

so than client want to view this bar chart as a 100% stacked bar chart 

so can you suggest the expression to achieve it.

Thanks in advance

-Eshwar

[Antoine04]

Hello Eshwar,

Is this what you want to do ?

Regards

Antoine

[Eshwar1]

Hi Antoine,

-Missed to mention earlier.

the report is with 2 Dimensions( Division and Segment) and 1 Measure (Last 3 months average value)

"Segment Composition by Division 100% Stacked Bar chart Last 3 months Average

On Stack: is Diviosion, Bars: Segment and Measure: Last 3 months average

Can you suggest the expression.