Pivot Table maybe?

Silvermini63

Active Member
Joined
Sep 25, 2006
Messages
293
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

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Forum statistics

Threads
1,136,989
Messages
5,678,975
Members
419,796
Latest member
doctorgresham

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top