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
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