Forum Discussion
Pivot Table Unique Values Get Individual Column, Do Not Get One Column with Unique Values in Rows
Dear Experts,
I am having this issue with my pivot tables where rather than having a "Users" column with all of my users listed in their own rows below, each unique user receives their own column. I just want a column header with the unique values below so it can be easily digested. Can anyone explain why this is happening?
7 Replies
If the Users field is currently in the Columns area of the PivotTable, move it to the Rows area.
This layout
is the result of
While this layout
is the result of
- Thanks for your response!! I have several fields, so when its just user it works fine... its when I start adding more. However, I found a bit of a workaround... I needed to revert back to the original pivot table settings that allow drag and drop. For whatever reason, adding fields to rows allows for the desired format you showed above! Another point... I have a lot of data and many of the columns are primarily text based with a lot of words, would removing the + and - signs make the appearance better?
- Also, is there a way to remove the "total" row that is included for each instance. I would only want a total at the user level, not any of the other fields
- For reference, I have obviously tried adding the fields to columns, and that is when I see each unique value getting its own column instead of stacking in one column as individual rows
