If i understand you properly, you want more than one row to be affected by the input value.
Cant we use If statment to do this with combination of varaible, like this
sum(if (WildMatch(Field1,'A','C','D'), Variable*Field2,Field2))
If this is not solving your purpose, please post the sample with your required o/p.
Well I have a pivot table with the salesmen names as dimension
in the expressions I have 3 columns A, B, and C
the data for A is read from database
Now the values of column C is the result of subtracting the value of B -A
values of column B are input by user
so suppose in some row in the pivot table the value of A is 500 and the user inputs 250 in the cell of B then automatically value of C in the same row is 250-500 = -250
can we accomplish this?
it is like in Excel!!