Forum Discussion

marsclone's avatar
marsclone
Icon for Helper IV rankHelper IV
6 years ago

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 ...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

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's avatar
    marsclone
    Icon for Helper IV rankHelper IV
    6 years ago

    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