Jul 29 2021 04:58 PM
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.
Jul 29 2021 08:39 PM
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.
Jul 29 2021 08:40 PM
Jul 30 2021 04:59 AM
Jul 30 2021 05:30 AM
Jul 30 2021 10:51 AM
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.
Jul 30 2021 11:08 AM
Jul 30 2021 11:48 AM
Jul 30 2021 12:21 PM
I saved the sample file here. Is this what you need? Thank you for your help.
Jul 30 2021 12:34 PM - edited Jul 30 2021 12:35 PM
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:
Jul 30 2021 12:38 PM
Jul 30 2021 01:00 PM
Learned something today. A mixture of different layout forms is possible. Just use the individual field settings and not the general setting.
Jul 30 2021 01:11 PM
Jul 30 2021 01:33 PM
Solution1) 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
Jul 30 2021 01:39 PM
@Detlef Lewin , each of us knows not more than 10% of Excel. Gurus with 30 years experience - maybe 15%. Majority - 1-2%.
Jul 30 2021 02:18 PM
@Sergei Baklan 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?
Jul 30 2021 02:35 PM
Jul 30 2021 02:40 PM
Jul 31 2021 06:13 AM
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
Aug 02 2021 05:26 AM
Jul 30 2021 01:33 PM
Solution1) 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