Values of an input field can be changed in list box cells, table box cells and in table chart expression cells.
But although its fine in list boxes and table boxes it doesnt seem to work on either pivot or straight table charts in v9sr4 - is this a bug or am I missing something?
That's the problem. Try putting InputSum(YourKeyFigureField) for Sum and InputAvg() for Average functions. Check help on these two functions and you will see what needs to be done.
The listbox and tableboxes do not need the aggregation function, but charts do.
I see. The problem I have is that these are text fields. I am using a chart rather than a table box as I create a calculated dimension to only show rows where an 'input allowed' flag is set (by using an 'if' in the calculated dimension then suppress when null).
