Forum Discussion
marsclone
6 years agoHelper IV
Price Volume Mix Analysis - Waterfall Chart
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 ...
v-juanli-msft
6 years agoCommunity Support
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
6 years agoHelper IV
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