Grouping in a pivot table

[mj_stev]

Good day,

I have a pivot table with items going down the left column of the table such as:

Product 1
Product 2
Product 3
Product 4

Products 1 and 2 are our main products. Products 3 and 4 are less important. I want to group products 3 and 4 into one category and call them other. This group should show the total of the two products and not the product amounts individually. How do I do that?

Thanks for your time,
Michael

 

[PaddyD]

In the source data:

=if(or(a1="Product 1",a1="Product 2"),"Main Group","Other")

 

[brites]

Select the lines, right click / organize, group.
Then right click again, organize..., hide details.

That helped?

 

[mj_stev]

Select the lines, right click / organize, group.
Then right click again, organize..., hide details.

That helped?

Yessir. That was it exactly! Thanks.