Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am using
INPUTFIELD Field1
in my load script and using
inputSum([Field1]) in the my expression.
I am able to enter the values for Field1 in the pivot table.
But this value changes by itself when ever i filter the chart.
I want to keep the value of Field1 unchanged.
Is there any way to do it?
-Jean
Even, If i filter it's not changing the value. i am not sure, Whether this is version issue or something.. If not, Please update work file
I think you are right
i was using
inputsum(Field1, '*')
* won't consider here. Use InputSum(Field1)
in fact, i will take my word back.
it is still changing.
it changes like this
suppose the initial value is 15 and this is how the table looks like
sales Field1 sales*(Field1/100)
1091753.25 15 163762.99
And then i select some filter like date which makes sales as 26643.32
then the value of Field1 changes to 10.38
I want it to be 15 always.
May be share application or images atleast. Before change and after change with filter?
Before
after date selection
The load script looks like
INPUTFIELD [Commission Rate]
and it is loaded as
0 as [Commission Rate], RowNo() as key
I added RowNo() because it was giving me "Duplicate keys when loading input field"
Is this is simple, please post sample application
what if we are using this? InputSum({1}Sales) // Sales you need to change?