Waterfall Question

[xuexi1890]

Hello

I build a waterfall chart, it is sorting by year and breakdown by customer at value

I have 1 existing customer with 4M$ increase in sales, and a new customer with 1M$ increase in sales from Y2018 to Y2019.

but what waterfall chart gives me is 1M$ increase in sales for the new customer not the existing ctm with 4M$ increase.

do you know why this happens? thanks!

regards

nate 

[v-lionel-msft]

Hi @xuexi1890 ,

You may need to  check whether the data in your data table is correct.

There is too little information, we can not judge where the problem is.

Or post a sample data.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@xuexi1890 , Can you share some kind of screenshot and explain

[xuexi1890]

@amitchandak  thanks Amit, it is corporate data, and it is an Azure based data pool. I'm checking with my colleagues, thanks for the help anyway.