Price Volume Mix Analysis - Waterfall Chart

[marsclone]

I'm trying to make a Price Volume Mix Analysis and put this in a Waterfall Chart, but i'm facing some problems.

The totals are working, but for some reasons results are not displayed right over the different product(groups).

In the Matrix table, values are not shown for the "productmix effect"

In the Waterfall Chart Matrix, values are not shown for the "productmix effect" but also the values for the "volume effect" are not right.

I've added a testfile, i hope you can help me?

Kind regards Marcel

Testfile 

[v-juanli-msft]

Hi @marsclone 

I'm not sure which result is correct for the measure "Productmix effect" and "Volume effect".

Could you add some slicers to limit the data and give a simple example with your excepted result?

Best Regards
Maggie

[marsclone]

Hi @v-juanli-msft 

The Test file i’ve added is a little example of my greater data.
In the middle of the sheet i’ve added a picture with the right values. The columns in yellow are the values that I want as my outcome.
I hope you can help me.
Kind regards
Marcel