Need Help with Pivot Table

L

Liz

On this Pivot Table I want to show:
row
Item # and Descriiption

Data
QTY
Price

Column
Date

When I put item and description in the row field I end up getting a sub
total for each row. How do I get rid of that???? note when I only use one
item in the row I do not get that sub total.
 
D

Debra Dalgleish

Double-click on the field button for Item#
Under Subtotals, click None, then click OK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top