[FIX] web: add support for string and invisible attributes in pivot view

The pivot view may sum fields that are not really summable:
    unsigned values (e.g. in the case of refunds)
    values in different UOM, currencies (any different units really)
Which causes confusion when these fields are displayed.

We add support for the string and invisible attributes in the pivot view,
so that a field can be given a more informative name or hidden altogether.

opw 1909046

closes odoo/odoo#29144

1 files changed, 9 insertions, 0 deletions

diff --git a/doc/reference/views.rst b/doc/reference/views.rst
index 52af59ecad4..cd96ae1b4a5 100644
--- a/doc/reference/views.rst
+++ b/doc/reference/views.rst
@@ -935,6 +935,10 @@ following attributes:
   the name of a field to use in the view. If used for grouping (rather
   than aggregating)
 
+``string``
+  the name that will be used to display the field in the pivot view,
+  overrides the default python String attribute of the field.
+
 ``type``
   indicates whether the field should be used as a grouping criteria or as an
   aggregated value within a group. Possible values are:
@@ -950,6 +954,11 @@ following attributes:
     ``week``, ``month``, ``quarter`` or ``year``) instead of grouping on the
     specific datetime (fixed second resolution) or date (fixed day resolution).
 
+``invisible``
+  if true, the field will not appear either in the active measures nor in the
+  selectable measures (useful for fields that do not make sense aggregated,
+  such as fields in different units, e.g. € and $).
+
 The measures are automatically generated from the model fields; only the
 aggregatable fields are used. Those measures are also alphabetically
 sorted on the string of the field.