4 Replies Latest reply: May 11, 2015 4:37 AM by Piet Hein van der Stigchel RSS

    percentage of sales

    Christian Wylezol

      Hi everybody,

       

      I have a Problem and hope that somebody of you could help me.

      I created a Pivot table of sales and want to see the percentage of total sales.

      The Formular for the sales is very easy (sum(valuehome).

      What Formular should I use to get the percentage regarding to total (i.e. 596632,83/7200600,81 =8,29%)

      I would have expect that "valuehome/sum(valuehome " would work but it doesnt.

      Maybe it would be also possible to define the total line (7200600,81) as Total line to calculate with that (but I dont know how).

       

      Does somebody of you maybe have an idea?

       

      Very much thanks in advance.