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
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.
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
elisape , you are welcome
- Thank you for your help. I really appreciate it.
Yes. First select to show all subtotals
After that in field setting for field for which you'd like to disable subtotals select
Result is
- Is there a way to "not show subtotal" for only the Client ID? For the Units, I'll need subtotals gourped by items.
SergeiBaklan I'm almost there! Now it looks like this, but how can I remove the grouping that formed in the name of client like in your pivot table?