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
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...
- This is exactly it!
I can't figure out how you changed it. I found the layout form under "design", but I don't know how to change it only for the Client Id.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
Learned something today. A mixture of different layout forms is possible. Just use the individual field settings and not the general setting.
Detlef_Lewin , each of us knows not more than 10% of Excel. Gurus with 30 years experience - maybe 15%. Majority - 1-2%.
I saved the sample file here. Is this what you need? Thank you for your help.
What you want is a mixture of compact form layout and tabular form layout.
I'm afraid you have to choose one of the three: