100% stacked graph from a percentage stacked graph

[vvvvvvizard]

sum({<FIN_YR_NO = {"<=$(vMaxFinYr)"}, MTH_SHORT_DESC=>}$(vMeasure_FieldName))
/
sum({<FIN_YR_NO = {"<=$(vMaxFinYr)"},Milestone={'Intake'}, MTH_SHORT_DESC=>}$(vMeasure_FieldName))

Good day

Below is my expression for a % stacked graph , how do i convert this graph into a 100% stacked graph ?

[JordyWegman]

Hi,

You need TOTAL for this. Check this video.

Jordy

Climber

[vvvvvvizard]

I had many other graphs that were just numbers , i did use total<yr_mth_no> eg it works easily , the problem is this graph is already in percentages and the total <> is not working

[JordyWegman]

What is the dimension you are using in your graph? You need to include this in your set analysis.

Jordy

Climber

[vvvvvvizard]

TOTAL <YR_MTH_NO, FIN_YR_NO, MTH_SHORT_DESC, FIN_QTR_NO,Fiscal_Year,Fiscal_YearHalf,Fiscal_Quater,Cal_Day,WEEKNUM,WEEKLABEL,Date, Cal_YearMonth, Cal_DayName>$(vMeasure_FieldName)),

[JordyWegman]

Your results should in the following syntax:

Sum($(vMeasure_FieldName))
/ 
Sum( TOTAL < [YourDimensionInBarChart] >$(vMeasure_FieldName))

You can expand the part before and after the / . But this is how you will get the 100% stacked charts.

Jordy

Climber

[vvvvvvizard]

Make the attachment a 100% stacked graph  

[JordyWegman · Accepted solution]

See the attachment. I've added another formula as test and added a type so you can clearly see the difference.

Jordy

Climber

[vvvvvvizard]

What happens if this my formula

(Sum(Contribution) * Sum(GL_VALUE) / count(DISTINCT Cost_Centre)) / count(distinct YR_MTH_NO)

How do i get 100% stacked i tried 

YR_MTH_NO is my dimension

[vvvvvvizard]

(Sum(Contribution)/Sum(TOTAL <YR_MTH_NO> Contribution))
* (Sum(GL_VALUE)/Sum(TOTAL <YR_MTH_NO> GL_VALUE))
/ (count(DISTINCT Cost_Centre) / Count (DISTINCT TOTAL <YR_MTH_NO> Cost_Centre))
/ (count(distinct YR_MTH_NO)/(count(TOTAL <YR_MTH_NO> distinct YR_MTH_NO))
)