Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have seen a few examples where inputing values into a pivot table is possible. However this has been done using inline tables.
Is it possible to create a pivot table with dimensions coming from table A, measures from fact B and have a col. where users can manually enter values to affect measure B within the chart?
Please let me know.
Thanks.
Hi,
Please find attached file for solution, in the pivot table you can change the price of a product in pivot table by clicking on the price cell in the table, so that the Total value is changed automatically changed based on the keyed in value.
This is achieved by using the InputField option and InputSum().
Hope this helps you.
Regards,
Jagan.