Skip to page contentSkip to chat
ServiceNow support
    • Community
      Ask questions, give advice, and connect with fellow ServiceNow professionals.
      Developer
      Build, test, and deploy applications
      Documentation
      Find detailed information about ServiceNow products, apps, features, and releases.
      Impact
      Accelerate ROI and amplify your expertise.
      Learning
      Build skills with instructor-led and online training.
      Partner
      Grow your business with promotions, news, and marketing tools
      ServiceNow
      Learn about ServiceNow products & solutions.
      Store
      Download certified apps and integrations that complement ServiceNow.
      Support
      Manage your instances, access self-help, and get technical support.
The Multipivot report translates the reference field only if in the first column and the first row - Known Error
  • >
  • Knowledge Base
  • >
  • Known Error (Knowledge Base)
  • >
  • The Multipivot report translates the reference field only if in the first column and the first row
KB0713003

The Multipivot report translates the reference field only if in the first column and the first row


390 Views Last updated : Apr 7, 2024 public Copy Permalink
KB Summary by Now Assist

Description

The Multipivot report translates the reference field only in the first column and the first row

Steps to Reproduce

  1. Activate activate plugin I18N: French Translations
  2. Activate plugin Facilities Service Management, including Demo data
    • Load the update set from the attached XML file which will:
    • Create a new table 'Facilities Typologies'
    • Create a new field in this table 'Typology'(type: Translated text)
    • Create a new label for this field for French language 'Typologie'
    • Add new fields to the new table and their translations
                 Value: 'Door' Translation: ' Porte'
                 Value: 'Floor' Translation: 'Sol'
                 Value: 'Copier' Translation: 'Copieur'
    • Add new reference field to 'Facilities Request' table referencing u_facilities_typologies.u_typology field and a new label for this field for French language 'Typologie'
  3. create a new Multipivot report 'Facilities report':
             Table: Facilities request
             Columns: Typology, State
             Rows: State, Typology, Assignment Group
  4.  Change the language to French
  5. Run the report 'Facilities report'

    Expected behavior: All text in the report is translated to French
    Actual results: The values in the second column are in English

 Now change the order of columns: Colonnes(Columns): State, Typology
Notice that once the values in the second row are not translated any more. The same as the values in the second column.



Workaround

 If a field is intended to be used for grouping, the type of the field should be 'translated field' instead of 'translated text'

Related Problem: PRB1240689

The world works with ServiceNow.

Sign in for more! There's more content available only to authenticated users Sign in for more!
Did this KB article help you?
Did this KB article help you?

How would you rate your Now Support digital experience?

*

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

What can we improve? Please select all that apply.

What are we doing well? Please select all that apply.

Tell us more

*

Do you expect a response from this feedback?

  • Terms and conditions
  • Privacy statement
  • GDPR
  • Cookie policy
  • © 2025 ServiceNow. All rights reserved.