How do I not summarize row data in a Pivot Table?

[alanschenk]

Hi everyone.


I have a problem that at first seemed simple, but I can't find the
solution. I'm using a Pivot Table to provide a report of my household
inventory, having columns of quantity, type (each, pair, set) and
description.


What I want to do is provide a report to my moving company which lists
each item in a row, example, 1 each bed, 1 each cupboard, 1 each table.

However, the pivot table summarizes the data and I only get one "1" and

one "each", but individual rows for the description, as you would
expect. What I actually need is a "1" and an "each" on every row for
the moving company report.


I've tried looking at field settings but that doesn't seem to help.
Therefore, is there any way of not summarizing data that is the same,
and treating each row as unique?


Thanks in advance.

 

[Dave Peterson]

You could change the pivottable to values (or a change a copy of that
pivottable), then you could use some techniques at Debra Dalgleish's site to
fill in those blank cells:

http://www.contextures.com/xlDataEntry02.html

 

[Debra Dalgleish]

A pivot table doesn't sound like the best tool for this. It's great for
summarizing numerical data.

If you've created a pivot table, you must have a list of items that you
used as the pivot table source. Can you sort that, and print it?

 

[alanschenk]

Thanks Debra

I've actually found the solution. I placed the description column as
the first column, this then sorted the descriptions alphabetically and
ensured that the quantity column and the Unit column had an entry in
for each row. Obviously the problem had something to do with the unit
and quantity being summarised, rather than the description.

By the way, love your website...very useful.

 

[Debra Dalgleish]

You're welcome! Thanks for reporting how you solved the problem, and for
letting me know that you like my website.