Pie chart with 2 measures

[keithericparsons77]

I am trying to create a pie chart with 2 measures...

measure 1:  Sum([Total Cost])

Measure 2:  Sum([Total Cost])-SUM([Labor Hours]*37.15)+ sum([MATL Chrg])

I thought a valuelist would be the answer but not sure how to write the formula.

[jwjackso]

It starts with your dimension, ValueList('Dept1','Dept2').  You then have only 1 measure, If(ValueList('Dept1','Dept2') = 'Dept1',Sum([Total Cost]),Sum([Total Cost]) - Sum([Labor Hours]....))

[keithericparsons77 · Accepted solution]

thank you sir, that worked!  much appreciated.

Dimension: 

ValueList('NON DWO','DWO')

measure:

If(ValueList('NON DWO','DWO') = 'NON DWO',Sum([Total Cost]) - Sum([Labor Hours]*37.15) + Sum([MATL Chrg]),
If(ValueList('NON DWO','DWO') = 'DWO',Sum([Total Cost])))