Pivot tables

Suite and Optimus Suite 5
#1

In your pivot table example you have one that says read only. This implies that ypu can edit the data in a pivot grid but I could not edit any of the pivot tables.

Can you load a grid. turn it into a pivot. Then edit the data in the pivot?

Here is what I want to do:

  1. create a grid and attach it to the database with the dataconnector so that updates happen automatically.
  2. Turn this table into a pivot table.
  3. Edit the data in the pivot table and have the change ( updated, inserted or deleted.) automatically change the base table (without extra coding).
  4. Then the changes in the base table will automatically be updated, inserted or deleted.

Is pivot tables only allowed in pro vesion?

#2

Pivot table is a separate instance of dhtmlxGrid. After you create pivot table, you can get reference to the pivot talbe object with following code:
var pivot = grid._pv;

After that you can initialize dhtmlxDataProcessor and link it with pivot table:

dp = new dataProcessor(url);
dp.init(pivot);

Is pivot tables only allowed in pro vesion?
Yes, pivot tables extension is available in PRO version only.