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