I have a requirement to create pivot table for an application. Here i have one pivot table which will display and capture the forecast data from the end user (using editing:true options and updataData).
However, i have to display historical data in another pivot table (in a different pivotcontainer). The cube / data for this new pivot table will be based on the selected row of the first pivot table (combination of customer + product + location etc).
Can you guide me on how to achieve this?
Thanks in advance.
Thank you for writing to us.
A possible solution would be to use Flexmonster’s context menu and add the option to display the selected cells’ data in a new pivot table.
The selected cells’ data can be retrieved by customizing the context menu.
We have prepared a JSFiddle showing how the selected cells’ data can be retrieved: https://jsfiddle.net/flexmonster/tpm97njx/.
Based on the selected cells’ data, you could compose the corresponding report object and feed it to the new instance of Flexmonster.
The following JSFiddle shows how to customize Flexmonster’s context menu to create a new pivot table: https://jsfiddle.net/flexmonster/dbaw72fw/.
Please let us know if this helps.