input inside a cell?

[ali_hijazi]

Hello

Is there a way to put an input object inside a cell of a pivot table or straight table?

I need it so that the user puts a value in this input on the pivot table and a third column is calculated based on the value entered by the user

[#2]

As far as i know you cannot do it for one cell of the pivot table, since i have tried to use the combination of 'Input sum' and 'Sum' in one expression, though it doesnt help to make the functionality up and running.

One idea, cant we do this with Inputbox?

- Sridhar

[ali_hijazi]

with input box then the desired column's value of all rows will be affected

I want only the selected row's desired column to be affected

[#4]

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.

-Sridhar

[ali_hijazi]

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!!

[deepakk · Accepted solution]

hi,

I hope the attach application helps you out.

Deepak