2 Replies Latest reply: May 5, 2014 9:36 PM by Denis Lomakin RSS

    Persantage in Pivot Table


      I am trying to build a report in pivot table that calculate the sales summary and the % for each month grouping by style, color and size.

      in order to calculate % I am using expression as following:

      .Sum(qty)/sum(total <style,color,csize> qty)  , but getting wrong result.

      Please see the attached excel file.

      What am I doing wrong? Thank you