Waterfall Chart & Bar Chart Offset

[StacyCui]

Hi, I want to create a waterfall chart. Ideally, I want to show the change from FY22 OR to FY23 OR on each flag.

I try to write it in two ways.

For the first one. I use waterfall chart. but the end of chart is  'Total'. 

The second one , I use Bar chart: I try to make the bar offset. But the negative value could not offset. 

How to solve it? Thank you so much.

I use Valuelist function in the dimension.

ValueList('FY22 OR',
'Sleeping',
'Lost',
'Signif Drop',
'Normal',
'Signif Grow',
'Woken Up',
'New with OR',
'New w/o OR',
'FY23 OR'
)

And Measure as follows:

if($(FY23 List) = 'FY22 OR', sum({< FY23_Flag_Type={'Total'}>}FY23_PY_Total_OR),
if($(FY23 List)='FY23 OR', sum({< FY23_Flag_Type={'Total'}>}FY23_CY_Total_OR),
if($(FY23 List)='Sleeping',sum({< FY23_Flag_Type={'Total'},FY23_Flag={'Sleeping'}>}FY23_CY_Total_OR)-sum({< FY23_Flag_Type={'Total'},FY23_Flag={'Sleeping'}>}FY23_PY_Total_OR),
if($(FY23 List)='Lost',sum({< FY23_Flag_Type={'Total'},FY23_Flag={'Lost'}>}FY23_CY_Total_OR)-sum({< FY23_Flag_Type={'Total'},FY23_Flag={'Lost'}>}FY23_PY_Total_OR),
if($(FY23 List)='Signif Drop',sum({< FY23_Flag_Type={'Total'},FY23_Flag={'Signif Drop'}>}FY23_CY_Total_OR)-sum({< FY23_Flag_Type={'Total'},FY23_Flag={'Signif Drop'}>}FY23_PY_Total_OR),
if($(FY23 List)='Normal',sum({< FY23_Flag_Type={'Total'},FY23_Flag={'Normal'}>}FY23_CY_Total_OR)-sum({< FY23_Flag_Type={'Total'},FY23_Flag={'Normal'}>}FY23_PY_Total_OR),
if($(FY23 List)='Signif Grow',sum({< FY23_Flag_Type={'Total'},FY23_Flag={'Signif Grow'}>}FY23_CY_Total_OR)-sum({< FY23_Flag_Type={'Total'},FY23_Flag={'Signif Grow'}>}FY23_PY_Total_OR),
if($(FY23 List)='Woken Up',sum({< FY23_Flag_Type={'Total'},FY23_Flag={'Woken Up'}>}FY23_CY_Total_OR)-sum({< FY23_Flag_Type={'Total'},FY23_Flag={'Woken Up'}>}FY23_PY_Total_OR),
if($(FY23 List)='New with OR',sum({< FY23_Flag_Type={'Total'},FY23_Flag={'New with OR'}>}FY23_CY_Total_OR)-sum({< FY23_Flag_Type={'Total'},FY23_Flag={'New with OR'}>}FY23_PY_Total_OR),
if($(FY23 List)='New w/o OR',sum({< FY23_Flag_Type={'Total'},FY23_Flag={'New w/o OR'}>}FY23_CY_Total_OR)-sum({< FY23_Flag_Type={'Total'},FY23_Flag={'New w/o OR'}>}FY23_PY_Total_OR)))))))))))

[Lisa_P · Accepted solution]

Have you tried using a Variance waterfall from the Custom Objects, Visualization bundle ?

[StacyCui]

Yes,  for the movement, it seems average. I didn't find anywhere to change the movement.

[Lisa_P]

I'm not really sure about how your data is created. It would be logical if you could use flag as dimension

[StacyCui]

It seems work. I change the dimension. Thank you so much.