Forum Discussion

marsclone's avatar
marsclone
Helper 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 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 

Need Help

2 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community 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
      Helper 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