Forum Discussion
elisape
Jul 29, 2021Copper Contributor
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...
- Jul 30, 2021
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
Detlef_Lewin
Jul 30, 2021Silver Contributor
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.