SumIf Expression Help?

[wholelottared]

Hi all,

Trying to create a stack chart with a SumIF. Goal is to create a stacked bar chart and visualize Enacted vs Final Budget.

Formula for one stack 1:  if([Enacted or Final]='Enacted',sum([FY19 Enacted Budget]))/1000000

Formula for the stack 2:  if([Enacted or Final]='Final Budget',sum([FY19 Enacted Budget]))/1000000

Any help would be greatly appreciated.

[dplr-rn · Accepted solution]

use set analysis

Formula for one stack 1:  sum({<[Enacted or Final]={'Enacted'}>}[FY19 Enacted Budget])/1000000

Formula for the stack 2:   sum({<[Enacted or Final]={'Final Budget'}>}[FY19 Enacted Budget])/1000000