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
)
