Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
)
No idea ?