search a method to calculate total by row in pivot table

[#1]

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

dim1	dim2	B1	B2	Total
A1		value	value	expTotal1
A2		value	value	expTotal1
A3		value	value	expTotal1
A4		value	value	expTotal1
A5		value	value	expTotal1
Total		expTotal2	expTotal2	i 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

)

[#2]

No idea ?