10 Replies Latest reply on Aug 25, 2016 5:01 AM by Yuriy Fal

    Super simple cascade chart - not doing what I want...

    Berthold Trenkel

      I've been waiting for the new cascade chart. But struggle to make it do what I want.

       

      I need to show on the y-axis the margin of the division, and on the x-axis scale the bars by sales of the division. Something as trivial as this:

      Header 1Header 2Header 3
      DivisionSalesMargin %
      A20010%
      B15015%
      C807%
      D5014%

       

      Finally I got it to work. But I need to add to the data another column in XLS that sets the correct starting point on the x-axis. Based on the cumulative sales volume. Starting from 0, then 200, 350, etc..

       

      Correct version:

      Screenshot 2016-08-24 10.09.47.png

       

      It should be simple to generate the same as running total of sum[sales]. But somehow it doesn't do it... I'm messing something up, when I use running total.

      Screenshot 2016-08-24 10.09.56.png

       

      Can anyone help please? And apologies for the trivial questions.

       

      Final pointer. How can I also get my bars sorted by size - from big to small sales. Or by margin - high to low.

       

      thanks so much

      Berthold