4 Replies Latest reply: Mar 7, 2013 11:54 AM by Fabio Marino RSS

    Wrong total in pivot table

    Fabio Marino

      I have an pivot table with this value. In the column "if sum" i want to display sumA if is >=1 or sumB if is <=0.

      When i collapse the dimension Agent or Customer the sub total is wrong. It do the total of the total of sum a or sum b and not the total of the colum "if sum"

      how can i do?

       

       

      AGENTcustomerSUM(A)SUM(B)if sum
      Agent1customerA077
      Agent1customeG01010
      Agent1customeL9109
      Agent1customeR5105
      Agent2customeB5105
      Agent2customeF5105
      Totale
      245741