Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
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!!
hi,
I hope the attach application helps you out.
Deepak