2 Replies Latest reply: Jun 28, 2017 12:48 PM by Carlos Daniel

Calculating line graph for all possible values of a dimension

I have the following measure in a line graph where my dimension is M1. However the graph only shows values when M1 is selected, and i'd like the graph to show values for every value in M1. Below the formula is a table with some example data about the values in M1.

(

Sum({\$<M={\$(=MFe)}>}np*fe_m)

+

Sum({\$<M={\$(=MFeAnt)}>}np*fe_m_ant)

+

Sum({\$<M={\$(=MFeAnt2)}>}np*fe_m_ant2)

)

/

(

Sum({\$<M={\$(=MFe)}>}fe_m)

+

Sum({\$<M={\$(=MFeAnt)}>}fe_m_ant)

+

Sum({\$<M={\$(=MFeAnt2)}>}fe_m_ant2)

)

MM1MFeMFeAntMFeAnt2
13321
23321
33321
24432
34432
44432
• Re: Calculating line graph for all possible values of a dimension

May be try using if statement instead of set analysis

(

Sum(If(M=MFe, np*fe_m))

+

Sum(If(M=MFeAnt, np*fe_m_ant))

+

Sum(If(M=MFeAnt2, np*fe_m_ant2))

)

/

(

Sum(If(M=MFe, fe_m))

+

Sum(If(M=MFeAnt, fe_m_ant))

+

Sum(If(M=MFeAnt2, fe_m_ant2))

)

• Re: Calculating line graph for all possible values of a dimension

Thanks, works perfectly.