7 Replies Latest reply: Aug 15, 2013 10:17 AM by Hannes Peiffer RSS

    Pie Chart with multiple formulas

      Hey to all,

       

      I think this is an easy one for the experts :-)

       

      I want to show the data in the attachment as a pie chart. I don't need a dimension, but sum up all the three values and show the percentage of the total. Each column has an own formula

       

      The result should look like this

       

      - Lohnkosten Soll: 9,31% ==> 480,95/5.165,69

      - Maschinenkosten Soll: 52,90% ==> 2.732,65/5.165,69

      - Materialkosten Soll: 37,79% ==> 1.952,09/5.165,69

       

      Thanks for any ideas :-)