5

I found, that I can use each field only once in Jide Table. For example, if I counted mean over some field I am unable to count sum over the same field.

Is it possible to overcome?

UPDATE

Here is an example of Jide PivotTable with field panel opened ar right:

enter image description here

As you see, fields, taken from fields panel and dragged to data area or row area, are disappeared from fields panel. This means that any field can exist only in one area.

The same implies from API method PivotField#setAreaType(), which has scalar argument. I.e. one field can be assigned to only one area type.

This caused me to duplicate field Region Area 4 times in underlying source: one for value, one for mean, one for min, one for max.

Simultaneously, the wish to have same field counted several times with different aggregation function looks general and it is strange, if PivotTable does not allow this out of the box.

Dims
  • 47,675
  • 117
  • 331
  • 600

0 Answers0