Pivot table on text fields

Seems the PivotDataWidget can handle text fields for the X-axis and the Y-axis, but not for cell value. Is there a possibility to have text fields for the cell value?
2 answers

If you just want to count cell values, you don't have to select a cell attribute. The other functions like sum and average can only operate on numeric values.

What do you want to achieve?


Actually not a true pivot table, but still an interesting use case for a dynamic table.

I can add action display, which shows the value(s) that exist at a given combination of entities A and B

This does come with a few restrictions:

  1. No aggregation takes place
  2. Row/column totals are not allowed
  3. Styling based on tresholds is not possible

Would that work for you?

Edit: New release is on GitHub: https://github.com/synobsys/mendix-PivotTableWidget/releases/tag/v2.2

Added display action and styling based on the displayed value. Useful for enums.

I also submitted it to the appstore. But I expect that will take a couple of days to get approved,