1 Reply Latest reply: Sep 23, 2011 3:24 AM by Martial Mazeleigue RSS

    search a method to calculate total by row in pivot table

      hello

       

      i will try to explain my problem by example

       

      i have a pivot table with 2 dimensions dim1 and dim2 and i have a "big expression 100 lines" exp1 and exp1=f(dim1,dim2)

       

       

      you can see a example to my pivot table

       

      dim1dim2B1B2Total
      A1valuevalueexpTotal1
      A2valuevalueexpTotal1
      A3valuevalueexpTotal1
      A4valuevalueexpTotal1
      A5valuevalueexpTotal1
      TotalexpTotal2expTotal2i search that

       

       

      my expression in pivot table as like

       

      if(isnull(dim1)=0 

           ,

           if(isnull(dim2)=-1 

                ,

                 expTotal1

                ,

                exp1

           )

           ,

            if(isnull(dim2)=0

                ,

                expTotal2

                ,

                i search that with a expression function to expTotal1 or expTotal2

      )