# Pivot Table maybe?

#### Silvermini63

##### Active Member
I have a excel file that has products, cost, sells, GP% product groups and descriptions on it and I want to have a revision page just showing the GP% that is made for each product group.

The problem is that it can vary from 50 odd to 300 products with a total of over 3500 products in 350 product groups so as you can see it need to be flexible and easy to use as it will be used by novice Excel users.

I tried a pivot table but this will not give me a place to have it do a GP% from the cost and sell….. What else could I maybe look at?

Eg….

Group Data Total
B16 Sum of Cost 93.89
Sum of Sell 101.62 7.73 7.61%
B98 Sum of Cost 63.22
Sum of Sell 71.37 8.15 11.42%
Q40 Sum of Cost 26.86
Sum of Sell 28.27 1.41 5.00%
Q55 Sum of Cost 10.48
Sum of Sell 11.14 0.66 5.94%
Q80 Sum of Cost 12.06
Sum of Sell 18.84 6.78 36.00%
Total Sum of Cost 226.50
Total Sum of Sell 253.66 27.16 10.71%

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Replies
5
Views
687
Replies
11
Views
1K

### Forum statistics

1,203,733
Messages
6,057,047
Members
444,902
Latest member
ExerciseInFutility

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back