Forum Discussion
Solved
Repeating values in a pivot table (instead of sum or count)
Hello,
I'm using a pivit table to organize information, but I can't figure out how to just repeat the values I have in the original table, instead of bringing the sum.
In the image above I'd like the pivot table to bring the original information for the Client ID, instead of "count" or Sum" or another formula.
1) Right click on any cell with this field and here Field Settings:
2) Here "Show item labels in tabular form" instead of this default
3) Ok
20 Replies
- If you don't want to summarize the Client ID, drag it into the Rows area instead of Values area. To do that, first uncheck the Client ID in the Field list and then click and hold the Client ID and drag it into the Rows area.
- Tahnk you for both your inputs. When I drag it into rows area, I get one row for each value. Is it possible to have one row for all values?
Move the fields into the rows area.
However, I don't know what's the advantage. The data then looks the same as in the original table. No aggregation.
