SAP Knowledge Base Article - Public

2825634 - Pivot/Chart does not display all labels / categories


Pivot Query / Chart reports do not display all labels / categories, in the column header/x-axis, respectively.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental


SAP SuccessFactors HCM Suite

Reproducing the Issue

  1. Run a Pivot/Chart report as User A
    1.  You will see data with different column labels (in pivot) and category labels (in x-axis of the chart)

  2. Now, run the same report as User B
    1. You will NOT see all the column labels (in pivot) and category labels (in x-axis of the chart)


Based on the data, which a particular user is having access to, the categories/labels will differ.

In the above scenario, User B does not have access to records/data with values 'Outstanding', 'Too New To Rate' or 'Unsatisfactory'.
Hence, they are not seen in the Pivot Columns as well as chart's x-axis (which is built using the same query as the pivot).


Working as intended: It is NOT possible to display cateories/labels with default value (such as 0 or '-') in Pivot / Chart reports.


pivot, chart, category, label, categories, labels, possible, default, value, values, ORD, component, table, canvas, report, reports, display, x, axis, header, column , KBA , LOD-SF-ANA-ORD , Online Report Designer , Problem


SAP SuccessFactors HXM Suite all versions