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...
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
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?
It would like like this:
Where I have the sum and summary for the number of unites, but for other values (like Client ID), I'd just show it.
- I don't understand what you mean. I can't provide a file because I don't know how to do it using a pivot table...