Sorting with PivotTable

[kaon]

Hi all,

I have spent half the day in finding how to solve the problem.

Suppose I have a list of products, with product price, ID, name, type
date of arrival, etc.

I want to sort the products by their type and print the correspondin
details together on a report, i.e.

Type A
Orange ID1234 $0.5
Banana ID1111 $1.0

Type B
Pear ID ID1112 $1.2

Type C
Cars ID1200 $50

Can I do so by pivottable? If no, any other good suggestion?

Thanks

 

[Debra Dalgleish]

Create a pivot table with type, name, and ID in the row area, and price
in the data area
Double-click on the Type field button
For Subtotals, choose None
Click the Layout button
Select 'Show Items in outline form'
Add a check mark to 'Display totals at top of group'
Click OK, click OK

Double-click on the Name field button
For Subtotals, choose None
Click OK

 

[kaon]

COOL!

That's almost what I want, but just some minor thing to ask.

price in the data area

This will be a header "total" in that column, can I rename or hide tha
cell?

Thanks

 

[Debra Dalgleish]

You can't rename it, but you can change its font to white, or a colour
to match the cell background.

If you refresh the pivot table, you may have to reformat the cell.